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
v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi sb19999 ,

 

Does you review and edit parameters in the tab for Datasets?

 

 

For more information, please refer to Edit parameter settings in the Power BI service 

 


If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

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.