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 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 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 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…
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…