Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. I could not find any blog posts or videos on how to do this. In my blog post I detail how to achieve this. Connecting to the dataset using Excel The method below will work…
Setting the Default Format String with Calculation Groups in Power BI
Recently I was working on a customer’s data and one thing that was missed was when something was not selected the Calculation Group did not return any default Format String. Below is how I solved this, with the tricky part being formatting of the measure to be displayed correctly. This follows on from my previous blog posts with regards to…
How to refresh Excel files faster in Power BI
I was recently getting an error when refreshing an Excel file that was stored in SharePoint online. This got me thinking what the issue is and is there a way to improve it and YES there is as detailed below. When I investigated this further, I found that my 17kb Excel file was using at least 616kb of data when…
You can now view the Power BI REST API calls via the Audit log
When I review the Power BI Audit logs, I am always finding either new operations or new additions into the audit log. In my example below I found a way to quickly and easily identify Power BI REST API calls that are being used. If you have not read my prior blog post where I detail how to store the…
How I changed the partition configuration (Year, Month, Quarter, Days) for my data in Power BI Premium / Power BI Premium Per user!
I have to say that I am quite fortunate to be a Microsoft MVP, and I am very grateful for the opportunity. This was one of those times when I was reading an email from Christian Wade and Christian had given me a little piece of gold. What is that gold you might wonder, well it is that there is…
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…