Forum Discussion

Puja_Kumari25's avatar
Puja_Kumari25
Helper III
3 years ago

Failed to update data source credentials for Http Odata web service NAV

Hi All,

 

I am not able to set credentials in Power bi service with BASIC option

 

URL : http://XX.125.XX.XX:XXX/DynamicsNAV801/OData/Company('XXXXX')/ListofOrders

Error: 

Failed to update data source credentials: The credentials provided for the OData source are invalid. (Source at http://XX.125.XX.XX:XXX/DynamicsNAV801/OData/Company('XXXXX')/ListofOrders.)

 

In power bi desktop able to fetch data succefully by using window credential.

 

With Regards

Puja

 

4 Replies

  • HI Puja_Kumari25 ,

     

    If you are using Window authentication in the Desktop, you should probably just use Windows authentication in the Service.  You also want to make sure that the Privacy level is the same on both.  So, it might be stopping the sign in based on the privacy level being different.

    • Puja_Kumari25's avatar
      Puja_Kumari25
      Helper III

      hi, there is no privacy level option in power bi Desktop. 

      and no window authentication in power bi services. 

      I have used odata feed for get data in desktop , in desktop working fine , but services not.

      • collinq's avatar
        collinq
        Super User

        HI Puja_Kumari25 ,

         

        Yes, there is a privacy level option for each Data Source within Desktop as shown here:

         

        That is what you need to confirm is the same on both.  This may or may not be the final problem, but this is a highly likely suspect.

  • theforce's avatar
    theforce
    Frequent Visitor

    I'm dealing with the same issue and neither of these options solved it.

    I also tried a personal token access (PAT) and couldn't make it sync once published - in Desktop it syncs just fine.

    Failed to update data source credentials: The credentials provided for the OData source are invalid. (Source at https://.....)