• Replies 8 replies
  • Subscribers 0 subscribers
  • Views 77 views
  • Users 0 members are here
Options
3sides - Social sharing widget
Related

HighQ data as data source to PowerBI

Ha Nguyen Danh
27249

Hi all, 

I've investigated in HighQ documents but there is no mention on integrating HighQ with PowerBI.

What I want to do is to connect PowerBI to HighQ data,  as far as I know this can be archived using:

- Connect PowerBI to HighQ Api 

- Using HighQ Connector to somehow pull data from HighQ (to a database?) and serve PowerBi (I just know the high level, no additional information about this)

Please help on documents/solutions to integrate PowerBI and HighQ data.

 

 

Parents
  • Thomson Reuters Thomson Reuters staff member

    Ha Nguyen Danh => The HighQ API is a REST API... Can you make http calls from PowerBI? I've never used it, but a cursory glance of the documentation would suggest so: https://docs.microsoft.com/en-us/power-query/connectors/web/web

    When importing data from the Web, if you select the advanced section, you can specify the necessary headers to construct a valid request for our servers. Those docs also state that PowerBI can handle XML and JSON, so you should be good to go.

    Not sure that PowerBI can handle everything required for seamless OAuth2 Authentication Code flow, but for adhoc queries it should be fine. Some discussion here:
    https://community.powerbi.com/t5/Power-Query/OAuth2-REST-API-as-data-source/td-p/414748

Reply
  • Thomson Reuters Thomson Reuters staff member

    Ha Nguyen Danh => The HighQ API is a REST API... Can you make http calls from PowerBI? I've never used it, but a cursory glance of the documentation would suggest so: https://docs.microsoft.com/en-us/power-query/connectors/web/web

    When importing data from the Web, if you select the advanced section, you can specify the necessary headers to construct a valid request for our servers. Those docs also state that PowerBI can handle XML and JSON, so you should be good to go.

    Not sure that PowerBI can handle everything required for seamless OAuth2 Authentication Code flow, but for adhoc queries it should be fine. Some discussion here:
    https://community.powerbi.com/t5/Power-Query/OAuth2-REST-API-as-data-source/td-p/414748

Children
No Data