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
Advocate IIThanks 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