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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
alops1
Frequent Visitor

Power Query DataSource.Error with api

Sto provando a connettermi a opentext tramite l'app, ma impostando la query su power query in questo modo ricevo questo errore:

 

alops1_0-1704975216767.png

 

alops1_0-1704975090749.png

 

2 REPLIES 2
alops1
Frequent Visitor

Hello and thank you very much for your interest.
I confirm that I have already tried with postman to verify the API and I get a positive response.
Furthermore, from PowerBI I tried to connect via WEB to the address and by entering the credentials I was able to log in successfully.

Anonymous
Not applicable

Hi @alops1 ,

"500: Internal Server Error" is mostly the server encountered an unexpected condition that prevented it from fulfilling the request.
There are several possible scenarios that can lead to this error. I suggest that you first test the availability of the API directly to make sure the headers information is correct. It may be that some of your headers are missing.
ML Studio (classic): Manage web services using API Management - Azure | Microsoft Learn
Also, please check if there are any problems with the data source itself. Here I have helped you to find threads where you have had the same problem and where you can try to find a solution.
Solved: DataSource.Error Web.Contents failed to get data f... - Microsoft Fabric Community
Solved: DataSource.Error : Web.Contents failed to get cont... - Microsoft Fabric Community
DataSource.Error: SharePoint: Request failed: The ... - Page 2 - Microsoft Fabric Community
You can also read this official documentation to see if you can troubleshoot the problem:
Troubleshooting the Power Query Web connector - Power Query | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 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