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 August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Accessing files stored on OpenText Content server

Hi There,

 

Does someone know how to access files stored on OpenText Content server from Power bi? 

 

Thanks,

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

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.

Anonymous
Not applicable

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!

Anonymous
Not applicable

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.

pallejohnson
Regular Visitor

I have the same problem, with Opentext Content server

Anonymous
Not applicable

Could someone please help me out with this?

Greg_Deckler
Community Champion
Community Champion

Seems there is a REST API?
http://axcelerate-docs.opentext.com/help/axc-main/5.15/en_us/content/resources/pdf%20guides/connecto...


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks!

And would you please be kind enough to show me how can i use rest Api to retreive data from content server?

 

Thanks,

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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