Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh

Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a data warehouse running on a relational database but with a little thought you can make it do all kinds of other interesting things; Miguel Escobar’s recent blog post on how to use incremental refresh for files in a folder is a great example of this.

Source : Chris Webb’s BI Blog
Read more…

Power BI desktop February 2020 is out and incremental refresh is now generally available!

Microsoft has announced the release of Power BI Desktop: February 2020 and you can read all about it here:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/

I am very happy about incremental refresh, which is now generally available and is now supported for Power BI Pro licensing, meaning it is no longer a Premium only feature!

Source : Think about IT
Read more…

Implementing incremental data load using Azure Data Factory

Azure Data Factory is a fully managed data processing solution offered in Azure. It connects to many sources, both in the cloud as well as on-premises. One of the basic tasks it can do is copying data over from one source to another – for example from a table in Azure Table Storage to an Azure SQL Database table.

Bron : Dutch Data Dude
Lees meer…