SSAS Tabular Model performance Issue
Hi I have a SSAS tabular model of almost 2 GB size. I refresh it's data using Azure Analysis Service on S1 tier(P.S. I have tried with S2 tier too but it still consume same amount of time) and refresh request is generated through ADF. Earlier it was working fine and refreshing data with 40 mins for all requested partitions. Now someone has added few new DAX measures to my model and since then me refresh time has increased to 3 hours. I want to optimize my model and reduce refresh time. I am only refreshing the relevant data(current data not the historical data). How can I reduce refresh time and optimize my tabular model. I tried reducing the data but still its taking long time to process the data which is not the ideal case. I guess the effectiveness is effected due to any DAX measure addition but still its just a guess. I dont know the method to identify the cause as I have too many DAX measures in my model.
Power BI Report Server - Live Connection to Azure Analysis Services
I have an Power BI Report Server and the associated edition of Power BI Desktop (September 2019). I am trying to create a Power BI report that gets data from an Azure Analysis Services tabular model via a live connection. After selecting Get Data > Azure Analysis Services database and entering the database details, I'm first prompted for my credentials, but then get the following error message: Cannot load model We couldn't connect to your Analysis Services database. Double-check that your server and database names are correct, and make sure you have permission to access them. Resolution of actual cluster endpoint of Azure Analysis Server: 'asazure://<region>.asazure.windows.net/<instance>' failed. Response from server: Technical details: RootActivityId: Date (UTC): I can import data into Power BI and I can connect to the model via SQL Server Management Studio using the same credentials, so not sure why I can't create a live connection? I am working on a server that might have some firewall restrictions. Power BI version: 2.73.5586.1501 64-bit (September 2019)
Dynamic row level security with Azure Analysis services tabular model Not working
Hi, I am using this Microsoft Article @ https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular -->Dynamic row level security with Analysis services tabular model Instead of using On-Prem Data sources I have used Azure SQL Database (AdventureWorksDW) and Created Azure Analysis Services Instance. Also in this I have used Azure ID in the format Username@Domain Name in the userSecurity table. But despite following up all the steps this is not working. Regards Rajaniesh
