Captain
Captain
765 views

Odata connection via Power BI

Hi,

Does anyone use Power BI as a reporting tool for Octane ?

Can someone provide which link has configure as Odata feed ?

Does link need to start with http or https ?

Regards,

 

Krešimir

 

0 Likes
4 Replies
Captain
Captain

Hello Ehud,

Thank you for replay, but it seems that I need to be more concrete.

So I have read all available documentation but if I use examples from documentation as power BI Odata data source I got following error's :

for example with http :

http://shpalmoctanep.ad.local/odata/v4/shared_spaces/1001/workspaces/5001

I got error :

OData:The request was aborted: The operation has timed out

for example with https :

https://shpalmoctanep.ad.local:8080/odata/v4/shared_spaces/1001/workspaces/5001

I got error :

power bi the underlying connection was closed: an unexpected error occurred on a send.

I have tried to use username and password and client secret and pass from api access. 

Regards,

Krešimir

0 Likes
Micro Focus Expert
Micro Focus Expert

Hi,
I understand that you get errors when trying to connect Power BI to Octane OData API.
In this case, I suggest that you will submit a ticket to support so that they will be able to provide the appropriate service.
Regards,
Ehud
0 Likes
Captain
Captain

Hi,

Yes I have open the case and resolved the issue.

It seems that problem was on our internal network (firewalls) but nevertheless there are some changes :

You should not use https but http link ( in documentation there is only https mentioned ). 

And instead of server name you should use ip address ( even do client is able to resolve host name to ip ) strange but this is how this works.

But now when this works one more important question :

How to get information from power bi in which phase ic which defect ?

I do not see any connection field between those two tables ?

Regards,

 

Krešimir

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.