Forum Discussion

bongmw's avatar
bongmw
Helper I
5 years ago
Solved

Manage Credentials Used When Connecting to Data Source

Hi all,

I have a Power BI report currently connected to Azure SQL using SQL Authentication. I am trying to update the data source to connect using a Microsoft Account instead.

 

After publishing the report with updated credentials, on Power BI service I see that the connection to Azure SQL is still using SQL Authentication.

 

Is this an expected behaviour? How do I manage the credentials that are used to connect to the Data Source?

 

We are not using a Gateway to connect to the source.

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi bongmw ,

     

    According to my understanding, even if you have updated the credentials in Desktop and then republished the report to Service, you will not change the credentials that you set up before in Service. I think you have to update credentials in Data Source Credentials like this:

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

3 Replies

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    5 years ago

    bongmw,

     

    Did you try to edit the credentials in Dataset Settings -> Data Source?

  • bongmw's avatar
    bongmw
    Helper I
    5 years ago

    Hi SivaMani 

     

    If you mean the Data Source Credentials section of Dataset settings in Power BI Service, that is where I have looked to see whether the new credentials have taken effect.

     

    Also I need this change to take effect at the Connection level, not at a Dataset level, if that makes sense. I do not want to have to update this every time the Dataset is published.

     

     

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      5 years ago

      Hi bongmw ,

       

      According to my understanding, even if you have updated the credentials in Desktop and then republished the report to Service, you will not change the credentials that you set up before in Service. I think you have to update credentials in Data Source Credentials like this:

       

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

      Best Regards,
      Winniz

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