460 questions with Azure Analysis Services tags

Sort by: Updated
1 answer

Insufficient permissions when I click on Log Analytics or Workbooks

I'm in the Entra Admin Center under Monitoring & health and click on Workbooks I get an error saying "Insufficient permissions" and then showing me this (Subscription-ID cc01... is changed, this is not the one that is shown in the real…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,330 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-11-12T18:02:09.4366667+00:00
Ludwig Wurmannstätter 0 Reputation points
answered 2024-11-15T18:58:27.16+00:00
Pranay Reddy Madireddy 625 Reputation points Microsoft Vendor
0 answers

Identifying Unused Tables in AAS Cube Over the Last 30 Days

I have a question regarding identifying unused tables in Azure Analysis Services (AAS). In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,005 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,942 questions
asked 2024-11-07T16:03:40.6433333+00:00
madmax 0 Reputation points
edited a comment 2024-11-15T08:58:43.61+00:00
Chandra Boorla 3,230 Reputation points Microsoft Vendor
2 answers

Analysis Service not loading big tables fully from SQL Server

We experience a very strange issue when uploading data from our SQL server to our analysis service, which we are hoping to get a bit of sparring on.   Briefly explained, the issue is that simple select queries for our largest tables terminate…

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,030 questions
asked 2024-11-13T10:01:00.3866667+00:00
Laurids 0 Reputation points
edited a comment 2024-11-14T20:24:23.0233333+00:00
NIKHILA NETHIKUNTA 3,270 Reputation points Microsoft Vendor
1 answer

Cant create new Analysis Services in D1 or B1 tier in West Europe

I am unable to create new services in D1 or B1 tier in West Europe region. Deployed in S0 West Europe or D1 in UK South went fine. I have also check and we didnt have such thing as quotas/limits for Analysis Services also, so I am not hitting any…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-11-14T10:00:35.4933333+00:00
Quyen Dang 21 Reputation points
commented 2024-11-14T15:35:27.8966667+00:00
Sina Salam 12,246 Reputation points
0 answers

Names of Azure Services in the Azure IP Ranges and Service Tags JSON File

What are the official names used for the following Azure services in the Azure IP Ranges and Service Tags – Public Cloud JSON file? Azure Function (AzFunction) Automation Account Azure Batch Analysis Services You can refer to the JSON file…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,143 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,263 questions
asked 2024-10-18T11:06:46.5433333+00:00
Nawani, Anubhav 0 Reputation points
edited the question 2024-11-04T05:02:30.1433333+00:00
vipullag-MSFT 26,396 Reputation points
3 answers

Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?

My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,030 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,291 questions
asked 2024-10-22T04:36:30.9633333+00:00
Jamie 0 Reputation points
edited a comment 2024-10-29T08:09:30.23+00:00
phemanth 11,455 Reputation points Microsoft Vendor
1 answer

Inquiry about Exported Log Verification on Power BI Service Workspace Reports

Hello everyone, I am exploring ways to verify the exported logs for reports on the Power BI Service workspace. According to the official documentation, does the event ID 92 “File Save Begin” indicate an export log? Thank you for your assistance! Best…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
473 questions
asked 2024-10-22T08:36:48.19+00:00
isukem 0 Reputation points
edited a comment 2024-10-24T14:16:19.73+00:00
Smaran Thoomu 17,120 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

How to use the format string function in the column properties to do custom formatting

Hello,   I have a date_key column with data type whole number and formatted as Text as shown below.     I want to apply this same logic to the date_key column in another table for my measure to work. I don't remember how to use the custom formatting and…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,291 questions
asked 2023-08-28T17:32:41.98+00:00
Cperer 21 Reputation points
commented 2024-10-18T14:39:12.8266667+00:00
Mattias Kuosku 0 Reputation points
1 answer

Import databricks data using tabular editor

I imported data from databricks to AAS using the Simba ODBC driver but after deploying the model, i can't seem to make the refresh work. I get this error "Failed to save modifications to the server. Error returned: 'Expression in partition…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-10-02T10:31:51.0633333+00:00
George Matlhogela 20 Reputation points
commented 2024-10-14T05:52:12.6133333+00:00
PRADEEPCHEEKATLA 90,241 Reputation points
1 answer

How do I create an Azure Analysis Services instance?

How do I create an Azure Analysis Services instance?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-10-07T13:47:19.03+00:00
commented 2024-10-09T16:35:11.0933333+00:00
Smaran Thoomu 17,120 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Permission on subscription when creating Azure Synapse workspace

I want to create a workspace subscript on Cosmos-bingads-bi, the website prompts me that I do not have the permission. Where should I apply for the permission?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,680 questions
asked 2022-02-17T06:41:21.4+00:00
Jie Li 71 Reputation points Microsoft Employee
answered 2024-10-05T18:37:18.8233333+00:00
Gabor Stefan 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can I connect to a databricks table and pull data directly into AAS for our daily data refresh (processing)

I want to connect to databricks tables directly using azure analysis services (AAS) and pull data into our AAS model during our daily model processing.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-09-25T11:07:04.0333333+00:00
George Matlhogela 20 Reputation points
accepted 2024-10-02T10:23:15.6566667+00:00
George Matlhogela 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure analysis services Scale out replica cost if I need S8v2 replica for 24hrs a month

Hi All, Can the Azure Analysis services Scale out cube replica be provisioned only at the time of cube processing?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-09-13T07:51:04.59+00:00
Rajiv Kumar Tiwari 20 Reputation points
accepted 2024-09-20T12:10:54.6766667+00:00
Rajiv Kumar Tiwari 20 Reputation points
1 answer One of the answers was accepted by the question author.

Simplifying data landscape with Synapse

How can I use Synapse to simplify my data landscape for maintenance and cost, assuming the lake is always a constant? I currently have two environments: Lake - Databricks(ETL) - Power BI Lake - ADF - AzureSQL - Analysis Services - Power BI I'm…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,005 questions
asked 2024-09-13T13:46:14.5966667+00:00
B 20 Reputation points
edited the question 2024-09-16T15:59:37.8733333+00:00
Bhargava-MSFT 31,121 Reputation points Microsoft Employee
1 answer

Error when deleting tables or when modifying column names in the tabular model

Hi, I am using tabular model level 1500. I have a postgres database that is connected to the azure analysis server through an on prem gateway. I have used powerquery to fetch data from the postgres database (via an odbc driver) to the model. I was able…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-09-06T16:39:37.4+00:00
Kartik Arcot 0 Reputation points
commented 2024-09-09T03:24:37.9233333+00:00
Kartik Arcot 0 Reputation points
1 answer

Unable to access the Azure Analysis services from Visual studio application

Hello All, I have deployed an Azure Analysis Service and enabled the firewall and Power BI. Users are able to access the Azure Analysis Service from Power BI, but they are unable to access it via Visual Studio from their desktops, receiving a network…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-08-28T13:48:39.4566667+00:00
saravanan vaithilingam prasad 0 Reputation points
commented 2024-08-30T14:24:24.35+00:00
Vinodh247 23,761 Reputation points MVP
1 answer

Analysis Services taking too much time to refresh SSAS tabular model

Hi, I have a data set of somewhere 40M records in SSMS. My tabular model earlier use to get refresh on S1 tier with 25-30 min. But now I'm using S2 tier and even still its refreshing the data at approx 60 min or sometimes failing and showing timeout…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,030 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,942 questions
asked 2024-08-25T23:34:49.5766667+00:00
Ali Javed cheema 0 Reputation points
commented 2024-08-29T16:06:00.04+00:00
Smaran Thoomu 17,120 Reputation points Microsoft Vendor
1 answer

How to change audience in token used for Azure Analysis Services REST API?

We use the Azure Analysis Services REST API to trigger model updates and refreshes. We received the following email from Microsoft indicating that the audience for the token used to make those requests needs to be changed. You’re receiving this notice…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,208 questions
asked 2024-07-26T17:37:15.8333333+00:00
Emmett Cregg 0 Reputation points
answered 2024-07-26T19:32:25.8333333+00:00
Bhargava-MSFT 31,121 Reputation points Microsoft Employee
2 answers

To Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS)

I'm not able to Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS), even though the MS Azure page here https://zcusa.951200.xyz/en-us/azure/analysis-services/analysis-services-datasource#tab1400a has given an option to read delta…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,491 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-07-01T08:29:19.1566667+00:00
Aravind K Pachaiyappan 0 Reputation points
commented 2024-07-18T12:20:02.0933333+00:00
Nehruji R 8,151 Reputation points Microsoft Vendor
1 answer

RLS on Azure Analysis service

I have a fact table and 3 dim table partner ,region and user and my user table contains the usernames and there respective access i:e user1 amazon and America , user2 flipkar and canada , so when ever user 1 logs in he should only see amazon and America…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
460 questions
asked 2024-07-15T12:12:21.4833333+00:00
farooq shaik 0 Reputation points
commented 2024-07-16T23:19:37.76+00:00
Bhargava-MSFT 31,121 Reputation points Microsoft Employee