Dec 7, 20178:33 AM - last edited on Apr 14, 202311:40 AM by MiaSrebrnjak
Member
Power BI Rest Api Dataset in Power Bi Desktop
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.
From what I understand you need a platform to inetgarte with data from Hubspot and replicate the same with customised reports on Power BI. At Sprinkle we have built a platform that exactly suits your need. Moreover, if you want to eliminate Power BI, we can provide you with Reporting platform at no extra cost.
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/
This change has been deployed. New uploaded form files will have the new Url format and will require HubSpot authentication to access. Existing form files will be migrated to the new authenticated urls over the next couple days.
We received NO notice of this change. Something this huge needs an email sent to your customers, period! I now know that I have to check your forum for updates (too late to inform me of this and not an efficient way for your customers to be informed of important updates such as this one.) Due to this surprise, my time was wasted on trying to figure out the problem and then sitting on the phone with hubspot tech support.
I literally just renewed our hubspot contract for 1 year and regret it; however, your lack of notice left me with zero time to prepare for an alternative.
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: