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 not validated on service side and thus not able to refresh the data.
 
Any idea as to what could be the problem or solutions to it?
 
PS: I'm trying to pull data from a third party application
Need Help

16 Replies

  • 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

    • 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

  • badda_khan's avatar
    badda_khan
    Regular Visitor
    3 years ago

    Hi h_pai_ 
    Can you please share the details, if you managed to resolve this issue. I am facing the same issue and I am pullying data from Postsgres.
    Regards

  • badda_khan's avatar
    badda_khan
    Regular Visitor
    2 years ago

    Hi Folks,
    Hope you are amazing.
    I need your need you help. I have created a sales dashboard fro my client. Its has card visuals like one card is showing current selected period sales and secound one is showing the sales period but for last year. Now I applid YTD slicer by creating new tables which filter date filter accordingly. Now the issue is when I apply YTD, QTD or MTD it filters the date table for current year due to which previous year calculation measures goes to blank. But I need to show the values for last year also. 
    Any idea how to resolve this issue.


  • florianh's avatar
    florianh
    Frequent Visitor
    1 year ago

    I had the exact same issue. For me it worked to turn on the “skip test connection”. I use the following setting: