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

      • learner03's avatar
        learner03
        Post Partisan
        3 years ago

        h_pai_ But, if it is fetching through API, shouldn't it be a cloud sorce and we shouldn't need gateway for this. I am having same issue. If I pas it through gateway, it works but as being a cloud source, it shouln't use gateway.