Issue with Toggling Between Different Databases on the Same Server in Power BI Service

[ashi7upt]

The issue with Toggling Between Different Databases on the Same Server in the Power BI Service

I have a Power BI report where users need the ability to toggle between different databases (DBs) located on a single server. The server name is fixed, but the database name will change based on user selection, with a default database selected initially.

• Scenario: On the Power BI desktop, I can handle this by binding a parameter to a column that allows users to switch between different databases.
• Problem: After publishing the report to the Power BI Service, I'm unable to dynamically change the connection string to update the database name based on user input.

Additional context:

• My SQL user account has SELECT access to all the tables across all the databases on the server.
• Each user should be able to select from his selected databases on the same server while using the published report.

Question: How can I enable users to switch between different databases on the same server after publishing the report to Power BI Service? Is there a way to dynamically change the database connection string based on user selection within Power BI Service?

[v-jiewu-msft · Accepted solution]

Hi @ashi7upt ,

Based on the description, try to click on dataset and modify the parameters.

You can also view the following blog to learn more information.

Using the Power BI Service Parameters to change co... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

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

[arvindsingh802]

Please refer to https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#add-param...