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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors