Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
6 answers
One of the answers was accepted by the question author.
Which is the best option for data warehouse / Power BI solution?
Hello, I am building a data warehouse in Azure from several external data sources. Data can be imported via pipelines in Data Factory (or Azure Synapse). Data is to be stored in Azure. Reporting through Power BI is required. There seem to be a…
asked 2021-10-19T10:02:24.153+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
System2000
236
Reputation points
commented 2024-01-31T15:35:11.7033333+00:00
Jack Fields
25
Reputation points
1 answer
Raw Data Excel to practice Power BI
Hi team, I'm practicing Power Bi service, I downloaded source from your Github, but data already transformed and pivoted. I want raw data to practice measure and data transformation skills. Can you give me the raw data of these sample: Retail Analysis…
asked 2024-01-28T07:58:23.5233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 13%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dat. Pham Quoc 2 - CTS TE.CTX.SC
0
Reputation points
commented 2024-01-31T06:46:46.49+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
Only the role Object ID is displayed in the tabular model's Role list, making it hard to understand the role name. Is there a way to fix this?
The object ID is displayed in SSMS and Visual Studio. Both applications show the object ID instead of the more user-friendly name. It isn't easy to manage roles for a tabular model. Software versions: Microsoft Visual Studio Professional version…
asked 2024-01-14T23:44:07.9166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 66%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jorge L Dominguez
46
Reputation points
commented 2024-01-24T17:40:03.7666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,136
Reputation points Microsoft Employee
0 answers
on-premises data gateway issue
My on-premises data gateway is not appearing in Azure when creating a new gateway, even though I selected the same region.
asked 2024-01-22T11:55:42.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 50%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQD%3C/text%3E%3C/svg%3E)
QServices Developer
20
Reputation points
commented 2024-01-24T05:55:19.3466667+00:00
Nandan Hegde
29,886
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services without Models
Hi, I am auditing an Azure account and need assistance with the Azure Analysis service. I have no knowledge of this service, but it seems to involve models. However, the Azure account I am auditing all resources of this service don't have any models.…
asked 2024-01-03T22:22:47.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 11%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Fábio Santos
65
Reputation points
accepted 2024-01-19T15:29:56.66+00:00
Fábio Santos
65
Reputation points
1 answer
Problems opening a tabular model file in different computer where it was created (localhost issues)
Hi! I have been working with analysis services for years (both olap and tabular). In the past, I was able to share the original files of a tabular model with my team members. I found that when someone different from the creator tried to open the file,…
asked 2023-12-14T08:12:44.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 98%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dani
0
Reputation points
commented 2024-01-12T18:28:12.9066667+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
On-Premise data Gateway connection to Azure Analysis Service
Hello All, I am trying to create On-Premise data Gateway connection from Power BI service to Azure Analysis Service (AAS) as my AAS has firewall blockage, but the new connection box only shows Windows authentication option. Is there a way using which…
asked 2023-12-29T12:40:29.9933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rohit
226
Reputation points
commented 2024-01-11T08:34:29.22+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Catch error when analysis services refresh fail and insert in a sql azure database
How can I catch error when analysis services refresh fail and insert in a sql azure database?
asked 2023-12-31T14:01:59.5133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 89%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sasha Sasha
200
Reputation points
accepted 2023-12-31T22:39:52.6+00:00
Sasha Sasha
200
Reputation points
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…
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? …
asked 2020-10-12T04:40:28.657+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
grajee
341
Reputation points
commented 2023-12-30T00:31:53.2066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
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?
asked 2023-12-22T17:25:00.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nitin Shikhare
0
Reputation points
commented 2023-12-28T05:24:20.7033333+00:00
AnnuKumari-MSFT
30,676
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…
asked 2023-12-27T16:09:09.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shreedevi Sendarapatti Ramamoorthy
0
Reputation points
commented 2023-12-28T05:05:55.1833333+00:00
AnnuKumari-MSFT
30,676
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…
asked 2023-12-12T15:18:31.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 65%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
iva rozelin
0
Reputation points
commented 2023-12-20T05:08:23.3033333+00:00
PRADEEPCHEEKATLA-MSFT
77,081
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…
asked 2023-12-14T11:11:16.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 10%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
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…
asked 2023-11-30T13:53:43.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 93%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DebLau
0
Reputation points
commented 2023-12-14T14:09:20.4566667+00:00
ShaikMaheer-MSFT
37,896
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…
asked 2023-11-16T14:34:36.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 98%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Maarten van Reek
1
Reputation point
answered 2023-11-17T11:30:11.8866667+00:00
ShaikMaheer-MSFT
37,896
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?…
asked 2023-11-13T13:50:42.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 68%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 16%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
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,…
asked 2023-10-27T08:01:12.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Josip Horacek
0
Reputation points
commented 2023-11-03T01:32:39.81+00:00
BhargavaGunnam-MSFT
26,136
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…
asked 2023-10-26T09:15:06.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 37%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Clare
0
Reputation points
commented 2023-10-28T19:24:58.9233333+00:00
Amira Bedhiafi
15,216
Reputation points