Semantic-Link-Labs – Automate updating your Incremental Refresh Policy for your Semantic Model
The scenario here is that quite often there is a requirement to only keep data from a specific start date, or where it should be keeping data for the last N number of years (which is the first day in January). Currently in Power BI using the default Incremental refresh settings this is not possible. Typically, you must keep more…
Incremental Refreshing – Part 4 – Migrating AAS to PPU
Welcome to the fourth instalment of my series on migrating AAS to PPU. In this blog post I am going to cover the differences, and pros and cons to incremental refreshing when migrating from AAS to PPU. The reason for incremental refreshing is that I do not have to reload the entire fact table every day when new data arrives….
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 to configure Incremental Refreshing in Power BI with DateKey or Date (instead of the default DateTime)
I was helping on the Power BI community forum (where I certainly learn a lot) and I came across this blog post where a Microsoft Employee had suggested that a Power Query function could be used as part of the Incremental refresh. What I mean by this is when implementing Incremental refreshing in Power BI the default is that you…
Ensuring your Power BI Incremental Refresh does not Timeout when using a SQL Server Source
I recently was updating my PBIX files to use the Incremental refresh. I ran into a timeout error as shown below. This was because on the first refresh it has to process all the data before it can incrementally refresh the dataset. As per the documentation the default timeout for a SQL Server database is set to 10 minutes, and…
#PowerBI RoundUp – Power BI Desktop release for Feb | Gartner Magic Quadrant | Service & Mobile Update for Jan | Petabyte-scale Analytics with Power BI & Azure | Incremental refresh & query folding | Premium Capacity Metrics Webinar
Well a lot has happened in the last week, with the desktop release (YAY!), and a whole host of other details. Read below for more details on what has been updated and from my perspective. Power BI Desktop Release for Feb Every month the awesome people on the Power BI Team release new features and this month is no different!…
BI-RoundUp – Power BI (Dashboard Theming – Incremental Refresh)
Another week has flown by and there are once again more Power BI Updates, which I really enjoy. But at the same time there is so much content and blog posts that at times it is a bit of a struggle to keep up with what everyone is doing. And with all of that I am still really enjoying being…
BI-RoundUp – Power BI Spring Roadmap (SSRS in the Cloud, Common Data Service for Analytics, Incremental Refresh & more) – Power BI Report Server Update – Building the Opioid Power BI Report
After last week, it appears that the Power BI team is still very busy, and after the announcement yesterday and the download of the Spring Roadmap there is a whole host of amazing things coming in the next few months! Power BI Spring Roadmap I will be going through the Power BI specific sections below to make it easier 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…
Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL)
Welcome to 2022, I am looking forward to an awesome year ahead! With the new awesome feature of now being able to use the Asynchronous refreshing with Power BI Premium/Premium per user I wanted to see if it was possible to use Power Automate to automate the process (Obviously). My goal was to be able to refresh an individual partition…