Forum Discussion

sb19999's avatar
sb19999
Advocate I
5 years ago

How to set datasource value on a parameter from Powerbi URL

Hello

I have two tables with same schema ( Table 1 and Table 2)

I have modified Table 2 'Navigation' steps as '= Source{[Schema="dbo",Item=DataSourceParam]}[Data]' where DataSourceParam is the parameter. 

What I am expecting to achieve is, if I pass DataSourceParam = Table1, then my visuals should load data from Table 1 and if I pass DataSourceParam = Table2, visuals will reflect Table 2 data. 

 

Now this is already achieved if I manually change the parameter value from PowerBI Desktop > Power Query Editor.

But the ask is to do it from Powerbi published report URL.

 

Please help!!!

7 Replies