Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerBI Service auto change Database Connection

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

Data Protection

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Icey
        Community Support
        6 years ago

        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.