Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Tag: Relationships

Tip to speed up Direct Query

Posted on July 18, 2019July 18, 20194 Comments on Tip to speed up Direct Query

This is not so much a DAX tip, rather something you might consider if you want to speed up the performance of any Direct Query (DQ) model you manage in Power BI or Analysis Services. The simple tip is to set relationships to use INNER JOIN rather than LEFT OUTER JOIN in the model. Once … Continue reading Tip to speed up Direct Query

Search

Categories

  • Advanced
  • Aggregations
  • Analysis Services
  • Blog
  • Calculation Groups
  • Columns
  • Composite Models
  • Data Modelling
  • DAX
  • Direct Query
  • Distinct Count
  • Easy
  • Filtering
  • Inventory
  • Medium
  • Optimise
  • Performance
  • Power BI
  • Power BI Refresh
  • PowerShell
  • Relationships
  • SSMS
  • Time Intelligence
  • TMSL
  • TOM
  • Uncategorized
  • VS Code

Recent Posts

  • Speed up Distinct Count calculations in Power BI using Aggregations
  • Using PowerShell to create Calculation Groups in Power BI Desktop
  • Power BI Storage Modes for Aggregations
  • Power BI Multiple Aggregations tables
  • Intro to Power BI Aggregations
Phil Seamark on DAX

Back to top
 

Loading Comments...