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
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. 

      • h_pai_'s avatar
        h_pai_
        Frequent Visitor
        3 years ago

        Ideally yes it should not be using gateway. But doesn't seem to work with out it. I don't know the reason behind it. But looks like there are issues it is a dynamic data source

    • abhay_jagtap's avatar
      abhay_jagtap
      New Member
      3 years ago

      Hi,

      I'm also facing the same issue, and for me "Gateway Connections" is disabled. 

      • h_pai_'s avatar
        h_pai_
        Frequent Visitor
        3 years ago

        Hi abhay_jagtap ,

        You need to first setup the gateway on a VM for it to work. You can use it on your local machine but remeber do not turn it off