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…
Updated Look for External Guest Users in Power BI (And a way to see the Navigation Pane)
I am fortunate to work across multiple Power BI Tenants, in some cases I have a local account and in other instances I work as an External Guest user. The first thing that I noticed when logging in is that there is an updated look for External Users who have had Apps, Reports or Dashboards. I have found that this…
How to use Vertipaq Analyzer with DAX Studio for Power BI Model analysis
If you are looking to better understand your Power BI Model, how big are your tables, which column is taking up the most space then you can use Vertipaq analyzer which is built directly into the amazing DAX studio. If you are looking for a video on how to do this, there are some awesome videos found here. SQLBI.COM –…
Quick tip on how to ensure your Format String Expression in the Power BI Calculation Group works
I was recently working on a more complex calculation group item and the corresponding Format String Expression. One of the things I did learn is that the Format String Expression is actually like any other DAX expression. It works in exactly the same way! How cool is that. Currently the only way to create and or edit the Format String…
How to easily remove a Power BI On-Premise Data Gateway from a Cluster
In the past when I had to remove a Power BI Data Gateway from a cluster, I had to use PowerShell with a couple steps which was rather complex. I recently found out that this can now be easily achieved using the Power BI Admin Centre in the steps below. Viewing the Current Gateway with the Cluster Members The first…
Get Power BI Desktop to write the DAX for you
Recently I had to get some data from a Power BI Dataset. At first, I started writing the DAX using the fantastic DAX Studio. Then a thought occurred to me, what if I could get the DAX already written and change it to my requirement. This would save me a lot of time and effort. I love the quote from…
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…
Power Query (M) – Passing Parameters dynamically to a SQL Server Query
I had a requirement where the client wanted the capability to decide how much data to load from a SQL Server Query (TSQL). This was so that they could limit the dataset returned, as at times they did not need all the data. So below I demonstrate how to achieve this. NOTE: This will be slightly advanced because I had to…
Using DAX to calculate Cumulative Target amount split into individual months
I had a requirement to take the overall target amount and split it for each month. But also, for it to be cumulative for each month going forward. The Target amount was 600,000 per month This is what the DAX measure looked like Target by Month = VAR MyTarget = 6 * 6000000 VAR TargetPerMonth = DIVIDE ( MyTarget, 6…
Did you know you can copy & paste images into the Power BI Community replies (And a tip to ensure it is large enough to see)?
I recently found out that I could now copy and paste images directly into a Power BI community reply. Previously I did have a blog post How to paste a screenshot/image into the Power BI Community Forum but it required a few extra steps. This has now been made a lot easier where I can now copy and paste my…