Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi There,
Does someone know how to access files stored on OpenText Content server from Power bi?
Thanks,
Solved! Go to Solution.
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.
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.
Thanks, Owen for your help!
I have been trying to make this work since late 2019 with no success. Eventually, I have requested data sources to be moved to SharePoint rather than using OpenText, However, I'm still interested in this solution. If you can show me how you did it since I don't have experience with Rest API.
Thanks for your time and help!
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.
I have the same problem, with Opentext Content server
Could someone please help me out with this?
Thanks!
And would you please be kind enough to show me how can i use rest Api to retreive data from content server?
Thanks,