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
1
vote
1 answer

Query to differentiate between Azure Analysis Services and SQL Server Analysis Services

Querying the server version information of Analysis Services, is there any clear way to determine whether the server you're hitting is the Azure Analysis Services managed service or whether you're hitting SQL Server Analysis Services running on a VM…
Tim Harris
  • 11
  • 2
1
vote
0 answers

DAX magic or new cube?

Is there a way to check from DAX, which Power BI report a user is opening? My problem is that I have a model with tables: -Revenue. -CostCenter. I have RLS set up for two special users: I take their USERNAME(), and I give these 2 users access to a…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
2 answers

Is there any Lync Services or connectors available for Azure Sentinel or Azure Log Analytics to connect Azure Data Factory

I need to pull the data from Azure Sentinel in an Incremental manner. E.g: step 1: Need a daily login details to my UI from Sentinel(using KQL) step 2: create a pipeline from ADF step 3: Load the data in tables Is there any Lync Services or…
subham das
  • 9
  • 1
1
vote
0 answers

ID cannot be specified for Azure Analysis Services role member

I am working on AAS Deployment via Azure Pipeline. While deployment when it comes to add ID in roles, it fails saying "ID cannot be specified for Azure Analysis Services role member." What ever email id, I am specifying under roles it fails for…
Sumant
  • 954
  • 1
  • 18
  • 39
1
vote
0 answers

Azure Datalake Gen1 connection for Azure Analysis services data models is failing by implementing via End-user authentication

I am using Azure Data lake Gen1 and Azure Analysis Services. I am authorizing my Azure Analysis Service's Data models with Azure Data lake connection. For this activity, Microsoft maintains a document. I am following the same way. Based on the…
Ashish-BeJovial
  • 1,829
  • 3
  • 38
  • 62
1
vote
1 answer

Service to service authentication is failing for Azure Datalake Gen1 to Azure Analysis services

I am using Azure Data lake Gen1 and Azure Analysis Services. I am authorizing my Azure Analysis Services Data models with Azure Data lake connection. For this activity, Microsoft maintains a document. I am following the same way. Based on the theory…
Ashish-BeJovial
  • 1,829
  • 3
  • 38
  • 62
1
vote
1 answer

Azure Analysis Services database model backups using powershell or azure cli

I'm trying to take backups of AAS databse models using below powershell script. I'm finding hard since there is no good Microsoft documentation around to implement this solution. $AnalysisServiceDatabase = "adventureworks" $AnalysisServiceServer =…
rewanth varma
  • 35
  • 3
1
vote
1 answer

Create an exact copy of Analysis Services database with AMO

I'm trying to automate the creation of an exact copy of an Analysis Services database using Microsoft.AnalysisServices namespace. My code is: using (var server = new Server()) { server.Connect(connString); var newDb =…
gmarchi
  • 11
  • 3
1
vote
2 answers

AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application: 'cf710c6e-dfcc-

I keep on getting this error: AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application: 'cf710c6e-dfcc-4fa8-a093-d47294e44c66'. Getting this error in Visual Studio in an SSIS project. In my…
JonathanBes
  • 11
  • 1
  • 2
1
vote
1 answer

Azure Analysis Service Rest API Error - Status 400 (Bad Request) with "unauthorized" message

I am trying to call the Azure Analysis Service API, to refresh my model, using this documentation as a reference, (https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh#post-refreshes) and I'm getting this…
Artur Quirino
  • 486
  • 6
  • 21
1
vote
1 answer

How Process Azure Analysis Services on SSMS Job

I currently have this flow local DB source -> Azure Datawarehouse -> Azure Analysis Service Model (deployed via Visual Studio 2019). I'm wondering whether there's a way to create and schedule a job on the local DB in order to refresh the Azure…
Camus
  • 827
  • 2
  • 20
  • 36
1
vote
0 answers

AAS Refresh Issue: The credentials provided for the SQL source are invalid

We have been trying to refresh AAS(full process) from SSMS with AAD authentication and from Azure runbooks with Service Principal authentication. But, we are getting below error in both the scenario: **Invoke-ProcessASDatabase : Failed to save…
V_Singh
  • 23
  • 2
1
vote
4 answers

AAS processing through Linked server: JSON DDL Request - Input string was on in a correct format

We have a setup where we are using azure analysis services instances for Power BI. These instances are connected via a data gateway down to on premise SQL servers. In order to process these AAS models we are using linked servers, as we can execute…
Boxx
  • 111
  • 1
  • 10
1
vote
1 answer

How to get list of roles and members in an Azure Analysis service via Powershell

We want to get the list of roles and members existing in an Azure Analysis services via Powershell. Is it possible? https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-powershell Based on these list , I did not get any list…
Priya Jha
  • 69
  • 8
1
vote
1 answer

AdomdDataReader GetValue(0) returning ???? instead of non-english characters

My goal is to grab all the unique values from certain columns in certain tables in an Azure Analysis Service via a C# Azure function app. My code works fine however the GetValue from the AdomdDataReader returns '?' strings instead of chinese…
programmingStudent
  • 13
  • 2
1 2 3
…
25 26