Overhead Of Getting Relationship Columns In Power BI DirectQuery Mode
Many Power BI connectors for relational databases, such as the SQL Server connector, have an advanced option to control whether relationship columns are returned or not. By default this option is on. Returning these relationship columns adds a small overhead to the time taken to open a connection to a data source and so, for … Continue reading Overhead Of Getting Relationship Columns In Power BI DirectQuery Mode
Published on:
Learn moreRelated posts
New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models
Some good news: an important optimisation has rolled out for Excel PivotTables connected to Power BI semantic models! Back in 2019 I wrote abo...
6 hours ago