How to enable dataset sizes larger than 10GB for Power BI Premium or Power BI Premium Per User
By default, when using Power BI Premium or Power BI Premium per user the dataset size is set to 10GB. I have had the wonderful experience of refreshing my dataset and getting the following error: In the steps below I will show you how to change this setting to allow for larger dataset sizes. Finding the dataset GUID The first…
Calculation Groups with Disconnected Tables in Power BI/AAS
Below I will explain how to use Calculation Groups with Disconnected tables. I know that some of this might be able to be done with other calculation groups. I find I have more flexibility when combining Calculation Groups with a disconnected table. Below are some of my previous calculation group blog posts that might also be of interest: Create Currency…
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 Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019) on how…
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 it into this blog post below. I am going to cover the following sections below…
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 or download any .ODC files. I am going to show you how to do this…
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 PBIX file being smaller than 1 GB and then moving to Power BI Premium where…
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 Let me start by saying when I log in with Power BI Pro, I am…
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 see other data. Row Level Security (RLS) is where I can create roles which can…
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 blank copy of your existing dataset. It then loads all the updated data into this…
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 the model, it just means that everything will run that much faster, process quicker and…