Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
0 answers
How to call websocket api and make a data set based on time?
I want to call websocket api from data anlytics or data factory which gives continous data from api. i want to read that data and based on time after every 5 minutes want to take out open high low and close values from that set. i can able to do it using…
asked 2020-10-11T07:36:44.293+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(294.40000000000003, 13%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
ashish fugat
11
Reputation points
commented 2020-10-22T16:58:21.693+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 Analysis Services: Purging Data
I want to make sure there are only 90 days of data in my Azure Analysis Services (AAS) model. I'm thinking about using Power Query/M to only filter the most recent 90 days and then doing a Process Full. Is that the best approach to this? If so, how…
asked 2020-10-15T14:33:26.647+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(54.400000000000006, 35%, 15%)' 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)
James H. Robinson
161
Reputation points
accepted 2020-10-21T13:46:38.213+00:00
James H. Robinson
161
Reputation points
2 answers
One of the answers was accepted by the question author.
Cannot connect Visual Studio 2019 SSDT to Azure Analysis Services
Hi, I have set up the adventureworks sample model in Azure Analysis Services. Firewall is off. I succesfully connected Excel, Power BI Desktop, Power BI Service and SSMS. This all works fine. Now I want to add a KPI to this model using Visual…
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,684 questions
asked 2020-10-09T14:29:52.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(54.400000000000006, 6%, 15%)' 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)
Bubenheimer, Martin
191
Reputation points
accepted 2020-10-16T20:59:22.82+00:00
Bubenheimer, Martin
191
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Analysis Service and Performance
All, We have an Azure Analysis Service of S0 Pricing Tier in production. I took a look at the Metrics in the Portal due to performance reasons and here is what I found: [1] Max QPU for Azureaasp1 is frequently 40QPU [2] Max Memory: Cleaner Memory…
![](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)
1 answer
One of the answers was accepted by the question author.
Cannot add calculation group to SSAS Tabular 1500 with direct query to SQL server
Hi, I am not able to create calculation groups on my direct query model. My tabular model is based on a single db source but I cannot seem to solve for the error when I need to create calculation groups. Neither tabular editor or visual studio are…
asked 2020-09-29T06:26:35.977+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, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tlou, Violet
21
Reputation points
accepted 2020-10-12T06:35:53.973+00:00
Tlou, Violet
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Query to get a list of Paritions
All, Would the DMV -- $SYSTEM.TMSCHEMA_PARTITIONS -- on AAS give me a list of Partitions in a Analysis Service Tabular Model database? We are trying to see if the "Basic Tier B1/B2" Pricing Tier would help us get more value for the same…
1 answer
One of the answers was accepted by the question author.
Is there still a Azure Analysis Services Web Designer (as of 10/09/20)?
Hi, In some blogs I saw people talking about an Azure Analysis Services Web Designer, mostly around 2017. Today I cannot find this Web Designer from Azure Analysis Services portal. Does this tool still exist, and where can I find it today? Best…
asked 2020-10-09T20:07:05.007+00:00
Bubenheimer, Martin
191
Reputation points
accepted 2020-10-09T20:19:09.84+00:00
Bubenheimer, Martin
191
Reputation points
0 answers
Azure Log Analytics or SQL Profiler for AAS?
I think you can use both SQL Server Profiler or Azure Log Analytics for Azure Analysis Services logging. But which one is the better option?
asked 2020-09-21T20:41:03.46+00:00
James H. Robinson
161
Reputation points
commented 2020-10-09T00:02:18.313+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,422
Reputation points Microsoft Employee
1 answer
DAX Approach to Inventory Problem?
I have data in Azure Analysis Services (Tabular) that looks like the following table. I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change. I think and IF function can take care of me…
asked 2020-09-30T00:51:29.637+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(128, 80%, 22%)' 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)
james.h.robinson.csm@gmail.com
6
Reputation points
commented 2020-10-07T06:43:06.397+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, 9%, 20%)' 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)
HarithaMaddi-MSFT
10,136
Reputation points
0 answers
Is it possible to send data from WPF app to Azure analytics?
Is it possible to send data from WPF app to Azure analytics? If yes, which is the minimum Visualstudio version & .net framework version required ? which are the best analytic services offered by Azure which can used with WPF app?
asked 2020-10-01T09:42:53.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(32, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hi
1
Reputation point
commented 2020-10-07T00:46:17.98+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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,036
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services: How to add Role Members to Models?
Hi all, I'm a bit stuck with this part of my Azure AS journey. Any help is greatly appreciated. I have a model that I have built out in Visual Studio and I am successfully deploying to Azure AS. I am now trying to add my power users to give them access…
asked 2020-10-02T05:04:28.323+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(268.8, 16%, 36%)' 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)
Me At Worky
21
Reputation points
accepted 2020-10-06T23:25:19.203+00:00
Me At Worky
21
Reputation points
1 answer
Do i have Azure Analysis Services in my tenant
Hi All, How do i know if i have Azure Analysis Services installed in my tenant? If not how to install AAS? Thanks
asked 2020-09-28T15:55:50.063+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(0, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bk
461
Reputation points
commented 2020-10-06T08:42:49.693+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
1 answer
AD group displays as long guid that starts with "obj:" when adding to Azure Analysis Services
I am trying to add a local domain security group to an azure analysis services instance as a Server Administrator. The group is synced with Azure AD and I am able to search for it by name and add it. When I attempt to add the group via the Azure…
asked 2020-09-30T21:20:56.417+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(198.4, 57.99999999999999%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JP
6
Reputation points
answered 2020-10-01T17:48:51.493+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,331
Reputation points
0 answers
Azure Analysis Services - Direct Query not supported for OAuth2
I am trying to build a Tabular Model but when I try to connect Azure SQL DW in DirectQuery mode "Failed to save modifications to the server. Datasource has authentication kind OAuth2. This is not supported in DirectQuery 1400 mode" As per…
asked 2020-08-21T20:22:34.163+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, 51%, 18%)' 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)
Ajit Kumar Singh
1
Reputation point Microsoft Employee
commented 2020-10-01T07:15:08.66+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(102.4, 52%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kjetil Smistad
1
Reputation point
1 answer
Azure DevOps - Test execution limitation
Hi, We are experiencing multiple issues using a manual testing module in DevOps. We have created a number of distinct Test Plans Group and Test Suite by function. We have the following needs where DevOps fails to provide any solution. Appreciate if we…
asked 2020-09-30T23:02:21.727+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(64, 44%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Biswas, Niloy @BlueScope
1
Reputation point
answered 2020-10-01T06:29:17.987+00:00
Leon Laude
85,676
Reputation points
0 answers
Error when importing Power BI Premium Model Into Azure Analysis Services
I have recently created an Azure Analysis Services model and created a connection with my power BI premium model. This PBI model has the XMLA set to read/write. I have successfully managed to create a connection between the two models using the PBI…
asked 2020-09-23T19:14:06.927+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(64, 33%, 16%)' 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)
VITOR SILLOS ALONSO
1
Reputation point
commented 2020-09-29T09:07:16.247+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
On premise data gateway connection issue
I have two global admin account with two different domain, and I want to use a single gateway for the CSV file access. when I log in with the first account then the second account gateway connection is out of the network. Please help me with the…
asked 2020-09-28T08:44:18.863+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(128, 62%, 22%)' 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)
Serosoft
1
Reputation point
answered 2020-09-29T06:03:27.57+00:00
PRADEEPCHEEKATLA-MSFT
79,141
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SQLServer 2019, Polybase and Tabular Model
All, From SQL Server 2019, how do I connect to SQL Server Analysis Server (Tabular Model)/Azure Analysis Service using "CREATE EXTERNAL DATA SOURCE". I would like to connect to it using Polybase and extract data from the Tabular data model.…
3 answers
One of the answers was accepted by the question author.
Analysis Services Tabular Model excel in sharepoint
I have created an analysis services tabular model. It has a database connection and a couple of excel files as data sources. When syncing the azure analysis services from the portal, the data does not update. It only updates if I publish from visual…
asked 2020-09-16T11:58:48.063+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(131.20000000000002, 62%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Palios, Jason
81
Reputation points
commented 2020-09-27T11:21:33.917+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(284.8, 81%, 37%)' 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)
Juli Lis
1
Reputation point
1 answer
Impersonation of Oracle Data Source in Azure Analysis Services
Hi All, We are using Azure Analysis services for building cubes, 1500 level compatibility. I am trying to understanding the impersonation settings while connecting to different data sources... For On-Prem SQL Server - We are using SQL Auth and…
asked 2020-09-08T15:20:24.34+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(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Praveen Yakkala
1
Reputation point
commented 2020-09-23T23:19:10.15+00:00
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee