431 questions with Azure Analysis Services tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

Cannot connect PowerBI to Azure Analysis Service

Until now, everything functioned smoothly. However, today we encountered a problem where both PowerBI Service and Desktop are unable to establish a connection with Azure Analysis Service. The error message indicates an inability to connect to the…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-12-31T13:53:07.37+00:00
Sasha Sasha 200 Reputation points
accepted 2023-12-31T22:39:28.02+00:00
Sasha Sasha 200 Reputation points
2 answers

Composite SLAs

All, This is a very generic question. The below link talks about SLAs and how to arrive at Composite SLAs. Is multiplying percentages even the right way to arrive @ a Composite SLA for an application? …

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2020-10-12T04:40:28.657+00:00
grajee 341 Reputation points
commented 2023-12-30T00:31:53.2066667+00:00
Dayo Faniyan 0 Reputation points
1 answer

How to allow Private access to Azure Analysis Server?

How to allow private access to Azure Analysis Service?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-12-22T17:25:00.4833333+00:00
Nitin Shikhare 0 Reputation points
commented 2023-12-28T05:24:20.7033333+00:00
AnnuKumari-MSFT 29,856 Reputation points Microsoft Employee
1 answer

Integration with ArcGis

I am trying to integrate various shape files from ArcGis source database to Azure. While exploring I understand that cant connect these files using Azure Data factory and can use Python scripts (GeoPandas) can be able to read these files from ArcGis. My…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-12-27T16:09:09.21+00:00
commented 2023-12-28T05:05:55.1833333+00:00
AnnuKumari-MSFT 29,856 Reputation points Microsoft Employee
0 answers

Analysis Service cube connector does not work with my Azure Service principal

Hi, I have two Analysis services Cubes - one is built upon DAX while the other is built upon M Code. After I created my Azure service principal, I successfully change the DAX cube connector and it works fine now. However, I try to change the connector to…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-12-12T15:18:31.9366667+00:00
iva rozelin 0 Reputation points
commented 2023-12-20T05:08:23.3033333+00:00
PRADEEPCHEEKATLA-MSFT 74,641 Reputation points Microsoft Employee
2 answers

use powershell script to extract tables and relationships from tabular model into csv

I would like to automate the extraction of tables and the fields in the relationships for an Analysis Services Tabular Model. Ideally this would land in a csv file in Azure Blob Storage in a table format similiar to…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,084 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,921 questions
asked 2023-12-14T11:11:16.61+00:00
Wayne Bartkowski 656 Reputation points
answered 2023-12-18T23:08:00.8233333+00:00
Wayne Bartkowski 656 Reputation points
1 answer

Why there are multiple records created in diagnostic log when a client application queries Azure Analysis Services data?

For an Azure Analysis Services server, I have added a diagnostic setting to send engine logs to a blob container. In the diagnostic setting, I have chosen the logs with engine as the category. The purpose of having this diagnostic setting is to monitor…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-11-30T13:53:43.5333333+00:00
DebLau 0 Reputation points
commented 2023-12-14T14:09:20.4566667+00:00
ShaikMaheer-MSFT 37,486 Reputation points Microsoft Employee
1 answer

Were SSRS Report Models (SMDL) a better semantical layer for operational reports than Tabular Models (PBIX Power BI Dataset) ?

Is a Tabular Model (in Analysis Services or Power BI/PBI Dataset) really a replacement for the (deprecated) SSRS Report Models? Tabular Models are made for BI/dashboards/PBIX (Power BI Desktop) reports to do slice-and-dice analytics while Report Models…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,756 questions
asked 2023-11-16T14:34:36.5866667+00:00
Maarten van Reek 1 Reputation point
answered 2023-11-17T11:30:11.8866667+00:00
ShaikMaheer-MSFT 37,486 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Extract data directly from Azure Analysis Services using Azure Data Factory

Hi I am trying to get data from an OLAP cube in Azure Analysis Services (AAS) source https://asazure://...europe.asazure.windows.net/model to Azure Data Factory (ADF) using query EVALUATE SUMMARIZECOLUMNS (....) Can you suggest any way how to do it?…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,267 questions
asked 2023-11-13T13:50:42.03+00:00
Mykola Avram 20 Reputation points
commented 2023-11-13T14:06:26.9833333+00:00
Mykola Avram 20 Reputation points
1 answer One of the answers was accepted by the question author.

Create a measures table in SSAS Tabular and Deploy to Azure

With the Import mode in Power BI , I used to create a table for measures. Now I want to do the same with SSAS Tabular and then deploy it.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2023-11-07T23:13:17.51+00:00
Lolipooop 180 Reputation points
accepted 2023-11-07T23:42:38.0466667+00:00
Lolipooop 180 Reputation points
0 answers

Counting distinct data from FACT table returns correct numbers but SSAS cube does not

Hi, I have a problem with distinct count measures in SSAS cube. When I check my FACT table numbers - they are correct but distinct count measure (in combination with location data) in a cube shows different numbers. When I do not combine location data,…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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.
12,403 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,239 questions
asked 2023-10-27T08:01:12.6933333+00:00
Josip Horacek 0 Reputation points
commented 2023-11-03T01:32:39.81+00:00
BhargavaGunnam-MSFT 24,726 Reputation points Microsoft Employee
1 answer

How to connect to an AAS model via Visual Studio Code again after it has been renamed

I have an Analysis Services Model that was created on visual studio, which was then deployed onto Azure. I tried to rename this model via SQL Server Management Studio, and this seems to be fine and the new name appears when I view the model on the Azure…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-10-26T09:15:06.1633333+00:00
Clare 0 Reputation points
commented 2023-10-28T19:24:58.9233333+00:00
Amira Bedhiafi 12,791 Reputation points
1 answer

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,373 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,239 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,624 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
commented 2023-10-26T08:47:18.04+00:00
ShaktiSingh-MSFT 12,851 Reputation points Microsoft Employee
1 answer

During AAS refresh we have been facing issue stating "Additional error details: DM_GWPipeline_Gateway_CanceledError The operation failed due to an explicit cancellation"

The Error details is mentioned in the image.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-10-09T17:58:09.5266667+00:00
Agamoni Ghosh (IN) 20 Reputation points
commented 2023-10-19T09:07:54.75+00:00
PRADEEPCHEEKATLA-MSFT 74,641 Reputation points Microsoft Employee
3 answers

How to solve the error "Not Supported in DirectQuery 1400 Mode" in AAS

I imported data into AAS, then I changed the DirectQuery Mode is ON. With the opening file, it was okay. However, when I closed and re-opened the file, it showed the error as below. I cannot open the model or change anything. When reopening, the…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-07-19T01:56:12.79+00:00
Katie Tran 5 Reputation points
answered 2023-10-17T23:00:09.8533333+00:00
Katie Tran 5 Reputation points
1 answer

Process Data + Process Recalc a AAS via Azure Data factory

Hello everyone, I am currently refreshing the AAS model in full mode using the REST API called from ADF, but the processing time of some tables is quite large. I have read some methods to reduce processing time, including the ‘ProcessData Plus…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,267 questions
asked 2023-10-12T02:52:50.66+00:00
ivan il 0 Reputation points
commented 2023-10-16T10:44:18.8433333+00:00
AnnuKumari-MSFT 29,856 Reputation points Microsoft Employee
1 answer

Analysis service over Power BI embeded

Hello, We experience performance problems with our current Power BI embeded capacity. We are currently running everything on our embeded capacity, but are looking into other solution to handle more users. By moving our data model to Azure Analysis…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,267 questions
asked 2023-10-11T09:42:59.88+00:00
Mathias Pabst Lassen Andersen 10 Reputation points
commented 2023-10-13T16:18:26.15+00:00
SaBo-MSFT 20,016 Reputation points
1 answer One of the answers was accepted by the question author.

Is caching entire Azure analysis services cube/model possible using Azure cache for Redis?

Hello, I am trying to access Azure analysis services Model data using web analytics. Due to huge data on AAS, It has performance issues. So wanted to know if we can cache entire cube/model data in redis cache to get faster response? if not how can we…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Cache for Redis
Azure Cache for Redis
An Azure service that provides access to a secure, dedicated Redis cache, managed by Microsoft.
205 questions
asked 2023-10-06T09:44:49.85+00:00
Sulbha Mule (AVANADE INC) 25 Reputation points
commented 2023-10-13T06:10:50.5366667+00:00
Sulbha Mule (AVANADE INC) 25 Reputation points
1 answer

Dependency analysis for 2016 windows server not supported?

We will scan the VMware environment of the customer , In the documentation (VMWare Dependency analysis agentless) I saw for dependency analysis its not supported for 2016 servers. I was wondering why 2016 is not supported and 2019 is supported?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure VMware Solution
Azure VMware Solution
An Azure service that runs native VMware workloads on Azure.
305 questions
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,337 questions
asked 2023-10-09T14:20:03.8866667+00:00
Zeynep Kamali 60 Reputation points Microsoft Vendor
answered 2023-10-09T19:05:23.1966667+00:00
BhargavaGunnam-MSFT 24,726 Reputation points Microsoft Employee
1 answer

Dynamics 365 User dataverse analytics refresh rate

Dear Azure Support, This monday we had a Go-live of our clients Dynamics 365 CE system. Now we would like to have an up-to-date User analytics. So, who has logged in etc. We found the D365 User Dataverse analytics but unfortunately the refresh rate is…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2023-09-25T11:31:22.9633333+00:00
Bram Boerman 0 Reputation points
commented 2023-10-09T05:02:58.7733333+00:00
AnnuKumari-MSFT 29,856 Reputation points Microsoft Employee