Forum Discussion
Can I query a Datasource based on an existing Dataset column?
Hi sabeer6870 ,
hope this helps...
You can generate a filter string as in this screenshot.
The filter string can be inserted as a parameter in the query.
You have to deactivate the Formula.Firewall and grant the Native Query Permission
Then you get the filtered results table.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Thanks mwegener but my use case much more complex, I actually changed the data while sanitization.
I tried all I could, now I am fairly confident that PowerBI Cannot do what I want.
Reiterating :
1. query SQL get some data
2. Use some columns from #1 to query another data source.
#1 Creates some regex that I want to use in #2. Anyway, I know why PowerBI prohibits that, because when you refresh your data all the query goes on parallel, hence cannot have dependency between two PowerBI queries.
I appreciate your responses, thanks again mwegener
Hi sabeer6870,
parallel loading can be deactivated.
If you have two interdependent queries, they will be processed accordingly.
Take a look on this.
https://www.thebiccountant.com/speedperformance-aspects/
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.Hi sabeer6870 ,
is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
