Refresh – Pardaan.com

Delaying Power BI Dataset Refresh Until The Source Data Is Ready

This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so the old data was being loaded by mistake. The best solution here is to use some kind…

3 December 2020

Data & Analysis

Speed Up Data Refresh Performance In Power BI Desktop Using Table.View

It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and then wait a loooong time for your data to refresh. Source :…

20 May 2020

Data & Analysis

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…

22 April 2020

Data & Analysis

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…

7 April 2020

Data & Analysis

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…

26 February 2020

Data & Analysis

How do I : Implement an incremental refresh in Power BI (Free or Pro)?

A question I get a lot in my Power BI training for Business Central, and non Business Central companies is the following: How can I implement an incremental refresh, without building a data warehouse and without buying a Power BI Premium license? Source : Think about…

11 February 2020

Dynamics NAV & BC Tips & tricks

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…

11 February 2020