Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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,