Forum Discussion

JonSwed's avatar
JonSwed
Icon for Advocate II rankAdvocate II
5 years ago

Performance question - create a reference table in editor or a calculated table?

Hi all! A performance question.  The queries I'm working with are 10 - 20 millions of rows (BigQuery Google Analytics data mostly). I've a few dashboards where I've created a 'bridge table' to ...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Using DAX tables is no problem if it better solving your problem.  The only downside is that you have both the query table and the DAX table in your model, so file size is bigger. 

 

If you'd like to optimize your query, you can share the M code to get potential suggestions from the community.

 

Regards,

Pat