PowerBI Service auto change Database Connection

[Anonymous]

Dear all, 

I created the connection from PowerBI service to Azure SQL service. In my scenario, if the connection from PowerBI to Azure SQL Service was disconnected, I want PowerBI service will auto change connection to SQL server on-premise. 

Please provide me the solution for this scenario. 

Thank you 

Tuan Tran

[GilbertQ]

Hi there

Currently that is not possible, you would have to open your PBIX, change the connection string.

Then upload to the Power BI Service.

You also would need to have the Power BI Gateway installed and configured with the data source to your On-Premise server.

And finally for your updated dataset you would have to change the connection to use the On-Premise connection.

[Anonymous]

Hi There, 

Could I suggest this ideal for the PowerBI techincal team :D. If I could, Please provide me the link to this channel. 

Thank you for you reply

Tuan Tran

[Icey]

Hi @Anonymous ,

You can post your idea on Power BI Ideas.

It is a place for customers to provide feedback about Power BI.

What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Icey

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