Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Tag: Power BI

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

Speed up Power BI reports using columns

Posted on July 8, 2019July 8, 20196 Comments on Speed up Power BI reports using columns

Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can be downloaded here. I have come across this scenario a few times recently, so thought … Continue reading Speed up Power BI reports using columns

Power BI and Regular Expressions

Posted on May 23, 2017May 24, 20175 Comments on Power BI and Regular Expressions

I read a quote somewhere along the lines of… If you are trying to solve a problem with regular expressions… you now have two problems This seems a little harsh for a useful tool that has been with us for what seems a very long time.  Plenty of languages offer support for RegEx string searching … Continue reading Power BI and Regular Expressions

Dynamic distances in Power BI

Posted on May 13, 2017May 23, 20175 Comments on Dynamic distances in Power BI

How to dynamically measure distance in Power BI

Posts navigation

Previous page Page 1 Page 2 Page 3

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

  • 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
  • DAX : Count number of last known state
Phil Seamark on DAX

Back to top
 

Loading Comments...