Forum Discussion
Creating "variable" for input query
Hi samw5 ,
Please create query parameter to change the data source dynamically instead of using slicer selection, you can refer the following documentations to achieve it.
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters
Dynamic Web.Contents() and Power BI Refresh Errors
Web.Contents with dynamic file URL
Best Regards
Rena
OK now while the filter would work, how could I possibly (not sure if that can even be done) use that ID value back into the original 2 tables queries?
That VAR_ID would need to somehow be inserted into my query. Not sure how to do that.
= let Source = Json.Document(Web.Contents("https://api.loganalytics.io/v1/workspaces/VAR_ID/query"
Hi samw5 ,
Please create query parameter to change the data source dynamically instead of using slicer selection, you can refer the following documentations to achieve it.
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters
Dynamic Web.Contents() and Power BI Refresh Errors
Web.Contents with dynamic file URL
Best Regards
Rena