Forum Discussion
Opentext Content Server
I have used documents in OpenText from Power BI via the OpenText REST API... but the problem I have is I need to hard code the API credentials in the Power Query code and I haven't found a way to integrate with Power BI's credential manager. The Power Query I used to open an Excel file from OpenText was (substitute in the username, password and appropriate OpenText API URLs and document ID for your org):
let
GetJson = Web.Contents("https://<opentext auth server>/authentication/credentials",
[
Headers = [#"Content-Type"="application/json"],
Content = Text.ToBinary("{""user_name"":""<user>"", ""password"":""<password>""}")
]
),
FormatAsJson = Json.Document(GetJson),
Ticket = FormatAsJson[ticket],
DocID = "1234567",
ExcelFile = Web.Contents("https://<opentext api server>/api/v1/nodes/" & DocID & "/content",
[
Headers = [#"OTDSTicket"=Ticket]
]
),
ExcelWorkbook = Excel.Workbook(ExcelFile)
in
ExcelWorkbook
If someone has a better way that doesn't have hard coded credentials I'd really appreciate that.
This might be a long shot, but we have implemented something similar to the above and it is working perfectly fine in Power BI Desktop, but once published to Power BI Service, it fails to refresh.
It appears to attempt a refresh but times out after 20 minutes or so. Editing the credentials in the dataset settings will only save if you select skip validation.
- Anonymous2 years agoNot applicable
Could you please elaborate on the query you are using? I am only looking to take snapshots of content, as I am preparing for a migration, and would like to view a report on how content is structured.