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 to Rafael Mendonç who actually figured this out. All that I have done is to…
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, is it possible to configure a CSV file to be incrementally refreshed using a similar…
How I saved 40%+ on my Power BI Dataset size
I have been working with a customer who has a fairly large dataset. Part of my role was to see if there was any way to see how I could reduce the amount of memory being consumed, whilst still allowing for the same metrics to be represented. Challenge accepted! I had already applied all the best practices in terms of…
Using Power BI Support to create a Support Ticket
Whilst I have been busy answering questions on the Power BI Community one of the things that I have found is that at times people with Power BI Pro or Power BI Premium are unsure where to create a support ticket which will allow them to escalate their issues. Below I explain how to do this. Creating Support Ticket The…
Hiding the Filter Pane on opening a report or in Full screen mode in Power BI
I was answering a question on the Power BI Community where a user was having a challenge when opening a report in Full screen mode and it kept on expanding the filter pane. This report was only going to be run in full screen. Below are the steps on how I solved the solution. I solved it by doing the…
Power BI RoundUp – Dataflows Generally Available | XMLA Endpoints | Azure Analysis Service available in Paginated Reports | Presentation Mode in Windows App | New Q&A Dashboard
After last week, where there were actually no new Power BI items to write about, the Power BI team sure made up for it in the past week. Please find all the updates below. Dataflows now Generally Available I have to give a big kudos to the Power BI team, to not only now having this as Generally Available, but…
BI-RoundUp – Power BI (Working with PowerShell in Power BI – Deprecation of Custom Visuals API 1.1)
Here is the weekly BI-RoundUp and at least this week it will be a quick read! Power BI – Working with PowerShell in Power BI I am not going to go into great detail here, due to Kay giving a detailed explanation how to use the PowerShell cmdlets. What I will say is that after reading through the above blogpost…
DAX (Power BI) – Dynamic TopN made easy with What If Parameter
In this post I am going to demonstrate how to create a Dynamic TopN slicer using a What-If Parameter. This will allow your user to simply use the Slicer/Slider to view the TopN values and as a bonus if the user slides it to zero, it will display everything! Who doesn’t like something that is easy to create, but makes…
Power BI – How to do Pagination in Power BI Reports
In this blog post I am going to demonstrate how to achieve Pagination in Power BI reports, using the new Bookmarking feature. I got this question from a follower on Twitter Murali Krishna With the new bookmarking feature there now is a way to make it appear that you can page through Power BI reports. Below is what it looks like in…
Power BI – Using Reports Usage Metrics to create Custom Reports & Leverage them for other App Workspaces
In this blog post below I am going to show you how I created my own Custom Usage Metrics Report. NOTE: This has been done using my Report Metrics and not the Dashboard Metrics. NOTE II: I am going to refer to the Reports Usage Metrics as RUM (It has a nice ring to it) And then how I changed…