The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Sto provando a connettermi a opentext tramite l'app, ma impostando la query su power query in questo modo ricevo questo errore:
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.
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.