Power BI report dynamically published in web site

[Anonymous]

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

[V-lianl-msft]

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]

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

[lbendlin]

That would be the safest option.

[lbendlin]

Sounds like you may need to consider switching to  Power BI Embedded (microsoft.com) .

[Anonymous]

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?