Forum Discussion

h_pai_'s avatar
h_pai_
Frequent Visitor
3 years ago

Failed to update data source credentials

Hi Community, facing the following issue on the Power BI service when using Web connector.   The credentials are validated and able to fetch data on Power BI desktop, but the credentials are...
Need Help
rachelgomez1234's avatar
rachelgomez1234
Helper I
3 years ago

Solution: If you get a credentials message, it could mean:

The usernames and passwords that you used to sign in to data sources aren't up to date. In the Power BI service, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

Mashups between a cloud source and an on-premises source, in a single query, fail to refresh in the gateway (personal mode) if one of the sources is using OAuth for authentication. An example of this issue is a mashup between CRM Online and a local SQL Server instance. The mashup fails because CRM Online requires OAuth.

This error is a known issue, and it's being looked at. To work around the problem, have a separate query for the cloud source and the on-premises source. Then, use a merge or append query to combine them.

 

Regards,

Rachel Gomez

  • h_pai_'s avatar
    h_pai_
    Frequent Visitor
    3 years ago

    Thanks for the reply but may be I was unclear.

     

    I'm using rest API to pull data using the Web connector which is available only on Power BI desktop. The API requires authentication. The credentials for the API work when using the desktop but give out the error in the datasorce credentials on the Power BI service

    • learner03's avatar
      learner03
      Post Partisan
      3 years ago

      h_pai_ Have you sorted this? I am having the same issue

      • h_pai_'s avatar
        h_pai_
        Frequent Visitor
        3 years ago

        Yes, I was able to solve this by setting up a On-premises data gateway

  • h_pai_'s avatar
    h_pai_
    Frequent Visitor
    3 years ago

    Thanks for the reply but may be I was unclear.

     

    I'm using rest API to pull data using the Web connector which is available only on Power BI desktop. The API requires authentication. The credentials for the API work when using the desktop but give out the error in the datasorce credentials on the Power BI service

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, did you get solution for the Problem, i am facing the same issue...Can you please help me..
      For me also the api data is working in the desktop when i deploy the dashboard it is giving error for authentication , in desktop i am using Basic authentication but if i use the same in web it is  not working