Forum Discussion

ChristianEvan33's avatar
ChristianEvan33
Frequent Visitor
3 years ago

Failed to update data source credentials: The credentials provided for the OData source are invalid.

Currently I have an issue with Refreshing the dataset that I uploaded to the Power BI web service. Please note that it works and able to refresh the data totally fine in Power BI Desktop. The i...
Dataflow
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , ChristianEvan33 

According to your screenshot , it works well in the Power Bi Desktop, but in Power BI Service, it seems the credential you provide is not right.

You need to go the Power Bi Desktop , and click "Transfor data"->"Data source settings" to see which credential you provide in Power BI Desktop:

You need to keep the same both in Power BI Desktop and Power BI Service. By default , the "Ouath2" is using the Azure Active Directory(AAD) as a credential , if your datasouce is not used AAD as an autentication mode , you need to change the autentication mode in Power Bi Service.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-yueyunzh-msft,

 

Could you please tell me how can we change the authentication mode in Power Bi Service?

 

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , Anonymous 

    If you need to change the authentication mode in Power Bi Service, you can fo to the setting of the dataset and then click "Data source credential" .

    And if you actually need use the "OAuth2" , you need to click "Sign in" and login in a user who has the permission for this api.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

    • ChristianEvan33's avatar
      ChristianEvan33
      Frequent Visitor
      3 years ago

      Thank you for your response. To clarify, does this mean that my user account requires either global admin rights or specific API permissions through Azure Active Directory (AAD)?

       

      Is this permission only necessary when refreshing data within the Power BI Service (Cloud)? I ask because I am able to refresh data from Microsoft Planner using the same organizational account in Power BI Desktop.

       

      Additionally, in Power BI Desktop there is no option to select “Oauth2” as an authentication method. Instead, I simply log in with my Organizational Account. Is this expected behavior?

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi , ChristianEvan33 

        The credentials you set is used for this data source instead of the user login on .

        We need to configure this data source with credentials that are accessed by permissions.In Power BI Service and Power BI Desktop, we all need to configure the corresponding credentials for the data source. Credentials are needed when we request access to the data source, and refreshing also requires access to the data source, so credentials are also required.

        To test , you can first try to make the same credential has been configureed both in Desktop and Service.

         

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

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