Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI report dynamically published in web site

Hi Mentors,

I have couple of Power BI report with pro license. I need to use "Directquery" to get real time data. These reports will be distributed using a website to the end users. Currently we are copying the "Secure embed code" and pasting the same in the web page.

Now, I need to use  the same report for different databases as multiple clients are having their own databases.

I have tried with dynamic connection string (by creating M query parameters) but that seems to be working only in PBI desktop and there is no way to use the connection string dynamically 

Is there any way to achieve this? Any help is much appreciated as this is a mission critical situation to us.

Regards,

Arup

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I am also thinking the same...however, it will cost much more than pro. Hence just looking for if there is anything available with pro license. 

      Is there any possibility to pass the database name using the parameters? 

      Otherwise how to proceed? Shall I need to create seperate workspaces for each client?

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    After publishing your Power BI file to the service, you can go to the dataset settings (under schedule refresh)

    You can then expand the Parameters section under dataset setting page, and change the value.

    Please refer to this blog:

    https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters 

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi V-lianl-msft,

      I have already gone through this but this is not a viable solution in my case. As in my case, I need to chnage the database name dynamically. Actually, my concept is single report with multiple databases, thats too the report will be accessed from an external website. Hence, it seems to be possible only if I can send my database name as a parameter to the "Embed URL" for the report.

      Still thanks for your reply. Please let me know if you have any better solution.

      Regards,

      Arup