I urgently require help/advice on the best route to follow.
I need to integrate MS Power Bi into my Bubble App. And then embed Dashboards into the App.
I cannot seem to find a way to directly connect Power Bi to the Bubble database.
Would it be better to send all data to a SQL server, and then to Power Bi from SQL?
Advice would be highly appreciated.
The dashboarding options PowerBI offers a pretty good, is it an option to embed PowerBI content in your Bubble app? For more information check this link.
Thank you for the reply.
The problem I’m struggling with a the moment is to GET data from Bubble to Power Bi. Can’t seem to figure that out with the API.
So I was wondering if it would be better to just try and do it through a SQL server?
Ah sorry Francois, it’s clear now.
It seems it is possible to use REST API’s as datasource in PowerBI, see this tutorial here. Bubble also provides REST API’s, the data api and workflow api, to enable external apps to get data from your app.
The fastest way would be to enable the data API in the settings of your Bubble app and check/mark the data types you want to expose:
The next step would be to follow the PowerBI tutorial and use the url for your app, the Data API root URL + the data type you want to expose, that would be something like https://[yourapp].bubbleapps.io/version-test/api/1.1/obj/[datatype], example https://francoisapp.bubbleapps.io/version-test/api/1.1/obj/dataforpowerbi.
For authentication you probably can use Bearer key authentication (using an API-key generated in Settings - API) or basic authentication where you provide a username and password.
Note: Bubble’s REST Api’s are paginated, so only return a certain number of records (see the docs), but it seems that should be no problem for PowerBI.
Btw, I have a project coming up where I need this too, so if you need some help, let me know. We’ll figure it out and help each other.
Let me know if y’all need Power BI help. I’m a Power BI MVP and I am glad to help others with PBI where I can. I’m also a Bubble newbie so hopefully we can help each other.
I’m trying to locate the most recent article on paging APIs. There was some newer guidance that ensures the model will refresh in the service. Also, check out https://community.powerbi.com. I think there’s a PBI Embedded forum. If not, there’s a huge number of posts that can be very useful that you can find via Search.
Your reply helped tremendously, thank you!
I managed to sort it out.
Sounds great, just let me know if I could assist with anything.
Sounds good, will certainly let you know if I get stuck. Thank you!