[SOLVED] Power BI relationships behind the scenes with SQL Server

Issue

I am using import mode with SQL Server on-premises and bringing in all required tables and create relationships. Does the indexing the columns involved in building relationship in PBI have any benefit in terms of report or data refresh performance? What happens behind the scenes in PBI?

Solution

In the import mode, data is read from the background SQL Server database and loaded into cache.

So, the indexes in datasource will give very good read performance. So, data refresh times will be faster. Read more on indexing for performance in PowerBI

But, the indexes will not be used, when you are working with report in the Power BI, as data is brought from cache(dataset). Dataset is holding the refreshed data and is being used in the reports.

Refer to below data refresh reference for PowerBI

Data Flow for Power BI.

Answered By – Venkataraman R

Answer Checked By – Cary Denson (BugsFixing Admin)

Leave a Reply

Your email address will not be published. Required fields are marked *