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

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?