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. .