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

 

Parents Reply
  • 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

Children
  • 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
  • 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