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…
Costs – Part 10 | Migrating from AAS to PPU
One of the most important aspects when looking to migrate from AAS to PPU is what will costs be. This plays an important part in the decision. In this blog post instead of doing an AAS and PPU comparison I am going to do this side by side, which I feel will make it easier to compare. In my opinion…
Row Level Security – Part 9 | Migrating AAS to PPU
In this blog post I am going to cover how to implement Row Level Security (RSL) when using AAS and how this can be done on PPU. In my example below I am going to show creating to simple RLS roles which will limit data for the users who belong to 2 roles. Role 1 – USA This role is…