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…

Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what happens when a dataset is refreshed, for example so you can find out exactly how long a refresh took, understand which tables inside the dataset contribute most to refresh times or which calculated columns or calculated tables take the longest to create.

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…

How To Use PowerShell To Refresh A Microsoft Dynamics Business Central On Premises Test Database

This article is only for on-premise installations of Business Central (BC). The cloud/SaaS version requires a completely different method of refreshing involving Sandboxes. The steps below might also work for older versions of NAV, but I have not done any regression testing.

Source : ArcherPoint
Read more…

Refresh a Power BI dataset that feeds from SharePoint list automatically

The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and dataset that fully rely on SharePoint lists. These lists are used by business groups that don’t have the rights to spin up and Azure SQL database or just want to keep a simple list to store their dimensions. SharePoint lists are great for that.

Source : Kasper On BI
Read more…