Creating Power BI Premium Per User or Premium Partitions with Tabular Editor
What I find I wanted to do with a new PPU Dataset with incremental partitions is I did not want to wait for the PBI Service to complete this. The reason is that very often there are issues, and it takes a long time to complete. I wanted to have the control where I can process the partitions as I…
I cannot connect to Azure Storage to back up my Power BI Premium Per User/Premium
What I did learn when working through the blog post is that I ran into some errors when trying to re-connect or trying to connect to the Azure Storage in my Premium App Workspace and it failed. The errors that I got were, “We couldn’t connect to Azure, but it’s likely temporary. Try again later or see details.” Below is…
Steps on how I backed up my Power BI Premium Per User / Premium Database
Continuing with my series of using Power BI Premium Per User (PPU), today I am going to show you how to back up your PPU database. As far as I am aware all the options below will work for Power BI Premium as well. To me this is critical when my dataset size grows. Especially when it takes multiple days…
How to resolve error when deploying changes to Power BI Premium Per User for Incremental partitions
I have been doing a lot of work recently using Power BI Premium Per User and recently I got the following error below when trying to update my fact table in Power Query. “An unexpected error occurred (file ‘tmsavepoint.cpp’, line 1503, function ‘TMSavePoint::GetProxyImpl’)” This is what the actual error looks like. This is rather a confusing error and it can…
Creating “Read” permissions on reports & datasets (Allowing to view datasets from remote apps)
I was recently doing some testing with regards to permissions on datasets in the Power BI Service, and I came across two things. First, was that I found I could create access to a dataset where the user’s permission was “Read” I subsequently found that when a user has read permissions to a dataset, they can access it even if…
Using PowerShell to run Power BI DAX queries and extract data to CSV
In this blog post I am going to show you how to use PowerShell to run a DAX query from my dataset, and then store the results in a CSV file. I will also include the PowerShell code! I really liked the awesome blog post by Kay on the Power BI Team which you can find here: Announcing the public…
How to show a different contact for each report/dashboard within a Power BI App
I recently got a request asking if it was possible to have a different contact person for each report or dashboard within a single Power BI App. The good news is yes, this can certainly be done, and I will show you below how I got it working. What typically happens when a Power BI App is created, is the…
How to connect to a Power BI Premium Per User using SQL Profiler
I was recently looking on how to use SQL Profiler to connect to my Premium Per User (PPU) dataset so that I could see where the processing of my incremental partitions was. When I first tried to connect using the default options, I got the error “Either the race with the ID of ‘AAA’ does not exist in the server…
How I added my Report Names to the Log Analytics Report
I was really excited to use the Power BI Log Analytics for Analysis Services Engine report when it was released along with this blog post from the Power BI Team: Announcing long-term usage and performance insights (Public Preview) | Microsoft Power BI Blog | Microsoft Power BI This is really a great report when using Log Analytics. I found the…
Conclusion of Migrating AAS to PPU | Part 11
This is my final post and conclusion in my blog series to look at migrating from AAS to PPU. I have really enjoyed the series and I have learnt a lot along the way, I hope you enjoyed following along! Conclusion Below is my outcome for each blog series, you can also click on the link if you want to…