How can I automate partition creation in Azure Analysis Services without using SPN Certificates?
I am currently using a setup where I create partitions in Azure Analysis Services database tables using Automation Runbooks, where we connect to AAS using SPN Certificates. Since Azure will be discontinuing the use of Certificates for authentication from…
Processing Of Azure Analysis Server Failed
Hi, we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error Error Details<br/><p style='color:red'>[{"message":"Retry attempts for failures…
Processing Of Azure Analysis Server Failed
we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error. {"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set…
Can't connect to azure analysis services with python and azure function using azure active directory.
Hi, iam trying to connect azure analysis services to query a tabular model using an azure function which is coded with python. The authorization is working through azure active directory and i setup oauth in my python script with token requests. The…
How to transform D365F&O data before connecting to power BI from synapses
Hi , I have created view in Azure synapses using CDMUtilSolution for data's exported from D365 F&O . Please help me understand how can I transform these data's and model this data in a better and cost effective way before loading and transforming…
Azure Analysis Services with Power BI Architecture
Hello, We have around 50 power bi reports connected Live to On-Premise Analysis Services, and we are migrating to Azure Analysis Services. When it was on premise it didn't matter if it was Live or import because we are were not charged by hour or…
Tabular model creates two databases using visual studio
Hello Experts, When I use the visual studio to deploy my tabular model it creates two databases. It looks like both databases have the exact same copies. I am not sure which one to use. Can you give me some insights on this. Do we know why there two…
How to deploy and refresh tabular model with AAD datasource
I have a customer looking to deploy an Azure Analysis Services (AAS) tabular model using Azure DevOps. However the underlying database is a Synapse Lake Database which does not support SQL authentication. All the examples seem to be for sql auth. They…
Azure Analysis Services S9 pricing tier is missing
Hi , I had recently upgraded the pricing tier of my Azure analysis services from S9 to S9v2 to check the performance. Since S9v2 incurs more cost , i wanted to scale down back to S9. But now the S9 pricing tier is not at all available in Azure portal…
How to stop cube processing that was triggered from ADF web activity
I have created ADF pipeline to process tabular model in AAS using web activity (By referring the url https://github.com/furmangg/automating-azure-analysis-services/blob/master/ADFv2/ProcessAzureAS.json). As web activity is an asynchronous call to process…
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…
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.…
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…
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…
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.
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. …
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…
Conversion overflows error in Analysis Services (Tabular)
Analysis Data Model Processing Failure.
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…
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…