Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Category: Performance

Debugging DAX – GuyInACube Video

Debugging DAX – GuyInACube Video

Posted on October 4, 2019October 4, 2019No Comments on Debugging DAX – GuyInACube Video

Last time I was in Seattle, I was lucky enough to do a short video with the famous GuyInACube showing a useful technique I use when debugging DAX in Power BI. I hope you find it useful.

DAX Fusion

Posted on August 5, 2019August 5, 20199 Comments on DAX Fusion

Introduction: Around 2014, an enhancement was made to the DAX engine designed to help improve query speed. The enhancement, called DAX Fusion, looks to reduce the number of storage engine scans needed to satisfy queries, by combining similar scans where possible. This optimisation feature exists in Power BI, so can be used to help speed … Continue reading DAX Fusion

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

Posts navigation

Previous page Page 1 … Page 5 Page 6

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

  • DAX Pareto Calculation
  • 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
Phil Seamark on DAX

Back to top
 

Loading Comments...