Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We have a application which stores data in Firebase DB in JSON structure. We want to connect those data in Power BI for reporting.
Can any one advise the steps that how to connect Firebase DB in Power BI.
Thanks in Advance.
I have managed to find a better way to link the data from Google Firebase to Power BI using JSON schema:
Hi,
I have gothrough the existing thread that we can able to pull Firebase data from two options.
1. Blank Query
2. BigQuery
I have been trying to connect above option, still looking how to find below option to find/enable from Firebase side. Could you advise?
From Blank Query: how do we find the Firebase DB connection url?
From BigQuery : I can able to connect Firebase from BigQuery, then I'm not able to see the Firebase DB JSON format tables. Any idea what to be enabled to get the Firebase DB objects in below?
We have these are the options within BigQuery enabling. Now sure which one is for Database tables(JSON structure) access.
Google Analytics
Crashlytics
Predictions
Performance Monitoring
Thanks.
Cloud Messaging
Import from BigQuery (Imported segments)
Get Data > Blank query
let Source = Json.Document(Web.Contents("url to firebase database")), #"Converted to Table" = Record.ToTable(Source) in #"Converted to Table"
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Thanks, I noticed your script in other link, but I'm not much clear where to get the firebase db url in firebase console. Can you able to provide steps that for getting firebase db url?
https://community.powerbi.com/t5/Power-Query/Loading-firebase-database-to-Power-BI/td-p/127669
you can also check this thread as well
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
https://hevodata.com/learn/firebase-power-bi-integration/#method1
you can follow these stips
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |