Home > front end >  Power BI relationships behind the scenes with SQL Server
Power BI relationships behind the scenes with SQL Server

Time:12-26

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?

CodePudding user response:

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. Data Flow for Power BI.

  • Related