Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
1 answer
One of the answers was accepted by the question author.
processing aas tabular model in visual studio results in two tabular databases with a model in each
Hi, when i build, deploy and process my Azure Analysis Services Tabular Model in Visual Studio and connect PowerBI to it, i always see two Tabular Databases. One has the normal expected name and the other one has a string attached to it. It looks like a…
asked 2023-05-24T14:46:20.19+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(182.40000000000003, 46%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gökhan Demirci
40
Reputation points
accepted 2023-05-29T10:04:43.55+00:00
Gökhan Demirci
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Criar partições no modelo do Azure Analysis Services via SMSS
Estou tentando criar partições de uma tabela usando o modelo do Azure Analysis Services, porém me retorna o seguinte erro: " Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity.…
asked 2023-05-12T18:50:55.65+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, 46%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Loren Rana da Silva Oliveira
41
Reputation points
accepted 2023-05-22T15:11:27.5966667+00:00
Loren Rana da Silva Oliveira
41
Reputation points
2 answers
SQL Auth for AAS
We have an azure analysis service with firewall enabled. So to refresh a powerbi report, accessing AAS I need a gateway. We have MFA enabled on our accounts so we are unable to set up the gateway. So is there are any other way like SQL accounts…
asked 2022-04-14T12:23:12.71+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(73.60000000000001, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sahil Mehta
61
Reputation points
answered 2023-05-19T05:16:06.9133333+00:00
Nandan Hegde
31,346
Reputation points MVP
1 answer
Copy data from AAS via ADF
I have a requirement wherein I need to copy data from AAS via ADF and I am following the below blog : https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/ But we have a scenario wherein we have MFA…
asked 2021-11-11T03:32:19.343+00:00
Sahil Mehta
61
Reputation points
answered 2023-05-19T05:14:20.5566667+00:00
Nandan Hegde
31,346
Reputation points MVP
2 answers
Installing on-premise-data-gateway on Azure Virtual machine
We need to install on-premise-data-gateway on Azure Virtual machine (VM) and mainly while configuring which instance of Azure Virtual machine (VM) is preferred.
asked 2020-09-07T10:44:22.67+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(144, 82%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vamshi Kishore KALIKOTA
51
Reputation points
commented 2023-05-12T14:20:27.7433333+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(150.4, 53%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pradeep Raju
1
Reputation point
1 answer
IP Address whitelisting in Azure Analysis Services for ADF SSIS-IR
We have the following simplified resources setup in Azure. There are SSIS pkgs which deploys and processes tabular models .bim files as XMLA scripts to AAS. The Firewall has been enabled in the AAS and the IP address of the SSIS IR is whitelisted. …
asked 2023-04-25T09:57:50.5333333+00:00
Subash Basnayake
61
Reputation points
answered 2023-05-02T21:34:05.9+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)
Bhargava-MSFT
28,951
Reputation points Microsoft Employee
1 answer
Is there an Azure SaaS or Plugin with WYSIWYG for building SQL queries and reports?
I am looking for SaaS solution to allow my end users to access and query their SQL data, to create BI charts and reports, etc. However, it must have a solution for complete SQL Illiterates (WYSIWYG). I found something called DataPine which is located in…
asked 2023-04-26T15:54:56.7+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(57.599999999999994, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Milan Polak
0
Reputation points
edited the question 2023-05-01T02:32:28.7833333+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
1 answer
Conversion overflows error in Analysis Services (Tabular)
Analysis Data Model Processing Failure.
asked 2023-04-12T19:38:33.83+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(51.2, 95%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Akinjide Akinwale
0
Reputation points
commented 2023-04-19T08:16:11+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Building a Data Dictionary for a Tabular Model
I used to have some SQL Server queries I could use to create a bus matrix & data dictionary from my old MDX cube through a linked server. We are now using Tabular Models in Azure Analysis Services and I was wondering if there are a similar set of…
asked 2023-04-12T11:32:24.1133333+00:00
Andrew Blyth
20
Reputation points
accepted 2023-04-18T09:44:48.19+00:00
Andrew Blyth
20
Reputation points
1 answer
How to ensure that my AAS tabular model is using AAS server processing power and not local system processing power while refreshing/processing the model?
Hi , We have created a tabular model using visual studio for 8 million records currently which took 2 hours. We have around 200-300 million records for which we want to create the tabular model to perform some load testing. What is the best way to create…
asked 2023-04-05T07:57:02.3566667+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(92.8, 21%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aishwarya Shirsathe
0
Reputation points
commented 2023-04-10T08:14:48.94+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Migrate dimensions in cubes to tabular
Hi Experts, I'm trying to replicate multidimensional cubes in tabular in order to deploy them on Azure. Now I'm trying to re-create the hierarchies in each view. In tabular each hierarchy level has a source column, does it correspond to Key Column or…
![](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, 55.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
How to process data from sql server to azure analysis service without getting timeout?
Hello! Every day, I need to process data from SQL Server to Azure Analysis Services (which I use as a data source for my Power BI report). I have set up a runbook in Azure that uses a PowerShell script to accomplish this. I followed this tutorial:…
asked 2023-03-30T09:45:37.5033333+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, 46%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Thor
1
Reputation point
commented 2023-04-03T04:54:20.2666667+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
Azure Analysis Services tabular model for 50 GB Data (Approx 99 Million Records))
looking for recommendation to deploy 50 GB Data in Synapse Analytics (Approx 99 Million Records), Please suggest if Azure Analysis services S0 is capable of deploying and processing this volume of data.
asked 2023-03-22T12:37:27.9533333+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, 53%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Abhijeet Kumar
0
Reputation points
commented 2023-03-30T19:44:18.0466667+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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Log Search API to Grab Information
Hello, Thanks ahead of time for any information you can provide. What I am attempting to do is this. I have a custom query that grabs the heal status of our vm. The in that query results i have the vms information like it if is health or unhealthy so…
asked 2023-03-24T20:21:10.3366667+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(12.8, 74%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
LaVar Blalock
115
Reputation points
commented 2023-03-27T01:46:50.27+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(60.8, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
26,131
Reputation points Microsoft Employee
1 answer
After cloning from Git the analsys tabler modle not showing the Tabular model explorer
Hi expert I am able to create Git Repo after downloading the cube from server Below is the options available but after cloning the Repo I am not able to see the Tabular Model Explorer even I tried to enable the from View --> other windows --->…
asked 2023-02-24T12:20:32.3366667+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(60.8, 22%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Hazarath Reddy Boreddy
1
Reputation point
commented 2023-03-08T22:18:49.73+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,442
Reputation points Microsoft Employee
0 answers
API pull of Azure Analysis Service Last modified time
I am trying to extract the highlighted value from a Azure Analysis Service. Looking at the regular API, this value is not available: GET…
asked 2023-02-26T15:11:23.17+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, 20%, 21%)' 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)
Lily
1
Reputation point
commented 2023-03-08T07:43:43.5466667+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
0 answers
Model (Bim files) repointing from Gen1 datalake in AAS to Gen2 datalake
Hi, I have around 30 models in AAS which are currently pointing to Gen1 datalake. I would like to repoint them to Gen2 datalake with minimum efforts. Is there any utility for the same?
asked 2023-02-28T15:12:12.65+00:00
Erika Gupta
0
Reputation points
commented 2023-03-06T15:33:36.08+00:00
Amira Bedhiafi
19,626
Reputation points
0 answers
Namespace error in Azure Function
I am trying to query Azure Analysis Services through Azure Synapse. As there is no connector to do so directly, I used Azure function to connect to AAS. But I am getting the below error: [Error] run.csx(7,17): error CS0234: The type or namespace name…
asked 2023-03-02T16:54:12.89+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(89.60000000000001, 50%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mohit Pawar
0
Reputation points
commented 2023-03-06T10:12:42.53+00:00
Mohit Pawar
0
Reputation points
0 answers
How to pass values from lookup activity to Web activity in azure data factory
Hi, I am attempting to refresh an Azure analysis using Azure Data Factory. When I use hard-coded values for the table name and partition name in the Web activity, the pipeline runs successfully. When I use a For Each activity to iterate through a list…
asked 2023-02-28T14:09:48.87+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(281.6, 70%, 37%)' 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)
muhammad abubakar
0
Reputation points
commented 2023-03-03T23:30:43.1466667+00:00
KranthiPakala-MSFT
46,442
Reputation points Microsoft Employee
1 answer
How to incrementally refresh Azure Analysis Services having synapse pool as source. Does “Default” processing option supports incremental refresh
Cube: Tabular (Azure Analysis Server)--- Source DB: Azure Synapse Pool --- Data Operation: Insert and update is happening on the source system Issue: Not able to get latest data from synapse pool in AAS cube, using "Default" processing…
asked 2021-01-29T18:41:35.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(38.4, 14.000000000000002%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vipul Singh
21
Reputation points
commented 2023-02-21T12:31:58.6966667+00:00
Kim Beck
25
Reputation points