Stack Overflow
Stack Overflow

Questions tagged [azure-analysis-services]

Related to Analysis Services running as the platform-as-a-service offering in Microsoft's Azure cloud.

Based on the proven analytics engine in SQL Server Analysis Services, Azure Analysis Services is an enterprise grade OLAP engine and BI modeling platform, offered as a fully managed platform-as-a-service (PaaS). Azure AS enables developers and BI professionals to create BI Semantic Models that can power highly interactive and rich analytical experiences in BI tools such as Power BI and Excel. https://azure.microsoft.com/en-us/services/analysis-services/

379 questions
22
votes
2 answers

How to choose between Azure data lake analytics and Azure Databricks

Azure data lake analytics and azure databricks both can be used for batch processing. Could anyone please help me understand when to choose one over another?
Pragmatic
  • 3,093
  • 4
  • 33
  • 62
17
votes
1 answer

Connect to Azure analysis services from python

I have Azure analysis service instance, with a tabular model, I need to query the data by DAX or MDX from a python script. I got a connection string from Azure that look's like this: Provider=MSOLAP;Data…
Itzik Friedland
  • 247
  • 2
  • 7
6
votes
2 answers

Azure Analysis Services versus Synapse Analytics

Can someone explain what is the difference between Azure Analysis Services and Azure Synapse Analytics? Why would one use Analysis Services over Synapse Analytics? Thanks,
Raju Joseph
  • 493
  • 1
  • 6
  • 13
5
votes
1 answer

Load data from Databricks to Azure Analysis Services (AAS)

Objective I'm storing data as Delta Lake format at ADLS gen2. Also they are available through Hive catalog. It's important to notice that we're currently using PowerBI, but in future we may switch to Excel over AAS. Question What is the best way (or…
VB_
  • 45,112
  • 42
  • 145
  • 293
5
votes
3 answers

How to add Azure Application Insights to a .NET Core App?

How does one add Azure Application Insights to a .NET Core App? I want to see search traffic analytics.
Nantourakis
  • 107
  • 1
  • 8
5
votes
2 answers

How is Application insight tracking the User_Id?

Im running a Azure Webapp with application insight. I know Microsoft cant show the real IP (Client_IP) so I add the real IP address to all requests (Ip). I have a visitor client_id="h9zbt" that in the last 24h is using 48 different client_IP…
Henrik
  • 243
  • 1
  • 3
  • 12
4
votes
0 answers

Add azure ad group to tabular model in visual studio

I try to add a azure ad group to a Role to a tabular model in Visual Studio. I have tried both to add the group through the visual studio (find user in the role editor) and change the code itself. But I get the same error when I try to open the…
Tysklind-MSFT
  • 87
  • 6
4
votes
1 answer

Does Azure Analysis Services support service principal signon to SQL Azure

I have an Azure Analysis Services model reading data out of SQL Azure with this connection string: Data Source=MySQLAzureDB.database.windows.net; Initial Catalog=MyDB;Persist Security Info=true; User…
Nick.Mc
  • 18,304
  • 6
  • 61
  • 91
4
votes
1 answer

How can I add Azure Active Directory group to role in SSDT tabular project?

I have SSDT Tabular Project which needs to be deployed to Azure Analysis Services. I created new role in tabular model explorer, but when I'm trying to add my group created in Azure Active Directory as a member of this role I'm getting errors at…
arghtype
  • 4,376
  • 11
  • 45
  • 60
4
votes
1 answer

Error connecting to Azure Analysis Services

I am new to analysis services on azure and trying to query it using AdomdClient. I downloaded the latest client libraries from here : https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers What I tried : I am…
frictionlesspulley
  • 11,070
  • 14
  • 66
  • 115
3
votes
1 answer

Excel Online connection to Azure Analysis Services?

Is it possible to connect to Azure Analysis Services from Excel Online? I can't find any option to do it, like in the offline version (Data -> Get Data). If I create a file in Excel desktop version and open it online there is a Refresh button shown…
saso
  • 754
  • 7
  • 18
3
votes
1 answer

AnalysisServices: Cannot query internal supporting structures for column because they are not processed. Please refresh or recalculate the table

I'm getting the following error when trying to connect Power BI to my tabular model in AS: AnalysisServices: Cannot query internal supporting structures for column 'table'[column] because they are not processed. Please refresh or recalculate the…
ChenDiagram
  • 31
  • 2
3
votes
2 answers

Invoke-ASCmd : Authentication failed: User ID and Password are required when user interface is not available

I am trying to refresh credentials of an (already)deployed Tabular Model via CICD using Azure DevOps. Making use of Invoke-ASCmd in PowerShell to refresh the credentials. The script works fine from local when I provide the Tenant ID, App ID and the…
Joseph
  • 530
  • 3
  • 15
  • 37
3
votes
2 answers

How Modifying Azure Analysis services roles using a logic app?

With Azure Data Factory I have built a pipeline to orchestrate the processing of my Azure Analysis Services model trough a dedicated Logic App as explicated in this article, and it works properly. Now, always using Azure Data Factory (through Logic…
Lorenzo Benassi
  • 621
  • 1
  • 8
  • 31
3
votes
1 answer

Multidimensional cube in AZURE

My database is created on Azure SQL environment and for reporting purpose I want to create multidimensional cube. But the problem is Azure didn't support multidimensional cube. So, Is there any alternative solution to perform multidimensional cube…
Manisha Chauhan
  • 63
  • 5
1
2 3
…
25 26