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 para...
Need Help
sb19999's avatar
sb19999
Advocate I
5 years ago

v-kkf-msft Changing parameter value from Dataset settings each time I want to switch to a different dataset is a manual task and is not the solution.

The business problem here is, switching between datasets having same schema on runtime. Something that I can feed into my powerbi url and it will generate the visuals with the data set. like query parameters which I tried to use (it filters on the visuals but not able to set data source with query parameters)

adamtoakley's avatar
adamtoakley
Regular Visitor
4 years ago

sb19999 Were you able to figure this out?

 

Thanks!

  • sb19999's avatar
    sb19999
    Advocate I
    4 years ago

    We did it through azure functions using power bi API to update parameter.

    • Arildsen's avatar
      Arildsen
      Frequent Visitor
      3 years ago

      Hi, care to share abit more details about the solution here?

      Having the same scenario where I want to set db schema (a parameter) based on the logged in user. I can do it manually now and the reports/data sets are updated accordingly, but I need the to be set when the usr logs in.

       

      Thanks.