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…
Deployments – Part 8 Migrating from AAS to PPU
Welcome to part 8, where in this blog post, I am going compare deploying datasets. For those people who are not exactly sure what deployments are, what this means is when you are using Power BI Desktop and you click on Publish, you are effectively deploying your changes to the Power BI Service (Which could also be a server in…
Modelling – Part 7 | Migration from AAS to PPU
In this blog post I am going to show the differences when creating a model/dataset when completing the same task in Azure Analysis Services (AAS) or Power BI Premium Per User (PPU) Here are the previous 6 blog posts that I have completed in the series. 1 – Query Performance – Part 1 Migrating Azure Analysis Services to Power BI…