Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Puja_Kumari25
Helper III
Helper III

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 4
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://.....) 

collinq
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




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.

HI @Puja_Kumari25 ,

 

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

collinq_0-1687961447155.png

 

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors