Chris Webb joins Patrick to look at what happens when you use reference queries for Power Query. This applies to both Power BI and Excel. Chris also looks at how change the behavior to make things a bit faster.
Data Privacy Blog: https://blog.crossjoin.co.uk/2018/12/27/data-privacy-settings-data-refresh-performance-power-bi-excel/
Download PBIX sample: https://guyinacu.be/referencequeriessample
Connect with Chris Webb:
Guy in a Cube courses: https://guyinacu.be/courses
Check out my Tools page – https://guyinacube.com/tools/