How to configure Incremental Refresh with Power Query in Power BI
Following on from my successful blog post How you can incrementally refresh any Power BI data source (This example is a CSV File), I found a way where I can just use dates created in Power Query to get data refreshing incrementally. Full credit goes…
Getting the correct Date Format to be displayed in the Power BI Service
Lately on the Power BI Community I have noticed people having issues with the date format not showing correctly. I thought I would post the steps on how to achieve this below. This is how my date was formatted before making the changes below …
Power BI On-Premise Data Gateway Error: DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1
I got the following error DM_GWPipeline_Gateway_SpooledOperationMissing”,”parameters”:{},”details”:[],”exceptionCulprit”:1 This error was caused because the current Virtual machine where the On-Premise Data Gateway was running was cloned and then started up. The result was that this then caused the Power BI Service to not correctly connect to the…
How you can incrementally refresh any Power BI data source (This example is a CSV File)
How you can incrementally refresh any Power BI data source (This example is a CSV File) I was reading the awesome blog post by Dustin Ryan (POWER BI INCREMENTAL REFRESH WITH WEB API DATA SOURCE) and what I saw him do gave me an idea,…
Did you know you can now selectively show report pages for specific users in Power BI?
With the update to the latest version in Power BI Desktop there is now the capability to control which users will see which pages in a report. This is achieved using a combination of Row Level Security (RLS) and conditional formatting. This makes it a…
How to fix Power BI Slicer Items that are not clickable because there are too many Visual Header Icons
Recently a user sent me a message saying that they could no longer click on a slicer item. I tried to myself and I had no issues clicking on the slicer item. I then had an online screen share with the user, so that I…
Power BI coupled with Power Automate allows for super-fast dataset refreshes
I found that using Power Automate to refresh Power BI Datasets allowed for refreshes to happen at the exact time I needed them to. This was because my underlying data warehouse load would vary, by using Power Automate it allowed me to have the Power…
Create Currency Formatting Strings using Calculation Groups in Power BI Premium (Soon to be Power BI Desktop) / 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…
How to create and use Calculation Groups in Power BI Premium / Azure Analysis Services / SQL Server Analysis Services 2019
I have been reading some great blog posts from SQLBI.COM on using and implementing Calculation Groups. What I did find is that currently there is not step by step process on how to get this working. This is what I will do in my blog…
How to refresh selected (not all) tables in Power BI Desktop
When working with Power BI datasets I often want to refresh multiple tables, BUT not all the tables in my model. (This often happens when I made a change to underlying data sources and I want to make sure it is working as expected in…