Forum Discussion
Advocate IIMake a shared query use another query as input (fix "may not directly access a data source" error)
Resolver IIHi freelensia,
As I understand your question you want all the queries to be stored in one central location so that it can be re-used multiple times?
According to me, there are two ways to do this.
1. Custom function: you can create custom functions and then it can be re-used in other queries
2. Data Flows: this is like, Power Query on the cloud. Where anyone within the organisation can use this.
Hope that answers your question
Regards,
Pradip Microsoft Certified Trainer
- freelensia
Thanks for the quick answer.
1. Yes I have created custom functions. However they can only be used in one Excel workbook, not multiple.
2. Data flows are not free, am I correct?
If so, these 2 suggestions do not solve my issue.
- PradipMCT
Hi freelensia
I though you're working in Power BI. Data flows only available in Power BI cloud. I am sorry i ran out of suggestions.
Regards,
Pradip Microsoft Certified Trainer
