Forum Discussion
sabeer6870
6 years agoMicrosoft Employee
Can I query a Datasource based on an existing Dataset column?
Hi, I queried a data source and got the dataset, in that datasource there is column lets say, "region". Region | Column2 | US East 2 | x | Asia West 1 | ...
sabeer6870
6 years agoMicrosoft Employee
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
mwegener
6 years agoMost Valuable Professional
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.