Power BI Rest Api Dataset in Power Bi Desktop


#1

HI,
I successfully managed to connect a java application to Power BI REST API and managed to create a dataset and added some data.

I can view this data from Power BI web interface, make reports, graph etc.

Is it possible to connect Power BI Desktop to this datasets and create custom reports from there? I’m asking this because the desktop application seems to be more complete. You can edit column names, merge tables, etc. all things that are not available in the web application.

Thanks all for the help.
hari


#2

Hi @kosmik5

There isn’t currently an integration between HubSpot and Power BI, though there may be 3rd party integrations that can connect the two (e.g. https://www.cdata.com/drivers/hubspot/16). You can also direct your team to our reference docs to give them an idea of what our public APIs are capable of:


#3

It is possible to use REST API Dataset in Power Bi Desktop since April 2017 and it worked for me in the latest version of Power BI Desktop.

But even though you can create reports based on datasets from Power BI Service, you still cannot edit column names, merge tables, etc.

You can get a detailed answer here:https://community.dynamics.com/gp/f/32/p/261145/737532#737532


#4

My firm is a HubSpot agency partner and has just launched an API integration for HubSpot and PowerBI. PM me for details.


#5

Hi @jelmer I'd like to have more information about this integration with hubspot and power bi. thanks


#6

Hi, please contact
james.elmer@bayardbradford.com to set up a demo.

You can also go to:
https://www.bayardbradford.com/hubspot-power-bi-integration-sign-up/

Thanks,

John

John Elmer

713 581 4725


#7

I don't have the perfect solution for this discussion but for the REST API, As I am beginner in this field so I research a lot and found another beneficial Article. I have found an Excellent tutorial where you can learn how to use a REST API as a data source. It includes JSON Source Connector, XML Source Connector, and REST API Task.
Check it out, https://zappysys.com/blog/howto-import-json-rest-api-power-bi/