Forum Discussion
Accessing files stored on OpenText Content server
There's a duplicate thread I answered here: https://community.powerbi.com/t5/Developer/Opentext-Content-Server/td-p/809913
I was able to read OpenText documents as data sources via their REST API but the solution isn't ideal as the only way I found involves hard coding the OpenText client credentials in the Power Query itself and not using the Power BI credential manager... I think because the OpenText API uses some specific/bespoke authentication that Power BI doesn't know how to work with.
No problem, at my company some I.T. staff specialized in OpenText helped by giving me a Powershell script to connect to the OpenText API that had the URLs and credentials I needed. I translated that script into Power Query which is what I posted on the other thread if you want to copy paste that as a new data source in one of your reports.
You'll probably need some help from some OpenText admin to know whether they've enabled the OpenText API and what URLs and credentials to plug into that Power Query to make it work for you. You do have to manually edit Power Query code to work with these REST APIs - it isn't quite as simple as working with Sharepoint.
Is there any chance you could post the PowerShell script you used to connect to the OpenText API? Obviously with a fake url and credentials, but it would be incredible helpful to see the general structure of that request in PowerShell.