Using the Power Query Reference Feature to Reduce Query Dependencies

Learn about an important feature in the Power BI query editor. Referencing other queries. Using this feature will help reduce query dependencies and allow for easier updates if the data source changes for the report.

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

[schajuli]

I have loaded some .xlsx from a folder location in such a single source "master" table. I thought it might be smart to reference this table then in other tables as I need it multiple times. My motivation was that due to that the loading times might be improved as I just load it in the beginning.

Well, it turns out that the same files are still loaded multiple times and this takes actually quite some time as the .xlsx files contain lots of data. So why is it atill laoding multiple containtimes and how can I prevent this?

[germanhenriquez]

Can I select which tables use in the reference query?? in order to use only necessary tables for my model

[PardeepKumar-lqwi]

When you will refresh, wouldn't it still load from your main access database for each query like 7 times queries access db.
You have brought convenience by defining to change connection only in main query but still the refresh issue and slowness will be there, what is solution to that?

[armstee]

How about performance? Does it reduce refresh time

[johnskilly]

Thank you for this, but then what? How do you change the data source for this one query? Once all the queries point at this data source query, what do you point that data source query at?

[rinaldobranquinho]

Is it possible to refer to a specific step of another query?

[adityakalra]

This video has enhanced my wisdom about Power BI,
Also, I request Reid to please be a bit slow while speaking... U are the fastest of all ;)

[johnmatta]

But that assumes all data are coming from the same source

[mshparber]

That’s interesting approach but 2 questions:
1. If I want to change the access file - i can do it in Data Source and it will change it for all connections at once
2. What about performance? Is referencing give us better or worse performance?
Thanks!