Create Currency Formatting Strings using Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019
Below are the steps on how I got the calculation groups to work for Currency formatting strings when the currency format string will be displayed per currency shown. Following on from my previous blog post (How to create and use Calculation Groups in Power BI…
Intro into Power BI Premium
I was chatting to my good friend Treb Gatte and one of the things we both discovered is that there was not a good blog post with regards to an introduction into Power BI Premium. I thought this was a great idea and have turned…
How to connect to your Power BI Premium Datasets using Excel (with the XMLA End Points)
I have had seen a few questions in the Power BI Community, as well as from other people asking if it is possible to connect directly from Excel to a Power BI Premium dataset from Excel. Without having to log into the Power BI Service…
Power BI Premium Performance – Part 5 | How much memory will the PBIX consume?
This was something that I thought I had covered off already and was one of the key messages that I wanted to get across when looking to move to Power BI Premium. It can be quite confusing when always thinking about the size of a…
Why do I have to pay for Power BI Premium features?
I generally see quite a lot of questions as to why certain features are only available in Power BI premium. In this blog post below, I am hoping that I can explain as to why there is a cost associated to them. Power BI Pro…
Power BI Premium Performance – Part 4 | How does Row Level Security affect performance?
In the third part of my blog series on Performance, this time I am going to see how Row Level Security will affect performance. RLS is an awesome feature when you want to ensure that only the relevant people can view their data and not…
Power BI Premium Performance – Part 3 | How does a dataset refresh affect performance?
In the third part of my blog series on Performance, this time I am going to show how a data refresh can affect performance. Below are the high-level steps as to what happens when you refresh a dataset The first step is it creates a…
Power BI Premium Performance – Part 2 | Optimization of your Power BI Model
In the second part of my blog series on Performance I am going to show how to look to potentially optimize your Power BI Model. The biggest impact you can have to the performance of your model is if you can reduce the size of…
#PowerBI Premium Performance – Part 1 | How to use the new XMLA End Point to see how much memory your datasets are using
With the new XMLA end points, it opens a whole new world of possibilities with Power BI Premium. This is part 1 of a series that I am going to be putting together series on how to make sure when moving to Power BI Premium…