Overhead Of Getting Relationship Columns In Power BI DirectQuery Mode
Chris Webb BI
MARCH 10, 2024
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 Power BI DirectQuery semantic models, turning this option off can improve report performance slightly.
Let's personalize your content