Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
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
That would be the safest option.
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?
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |