How to connect Firebase DB in Power BI

[Anonymous]

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.

[Anonymous]

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)

[mh2587]

Get Data > Blank query 

let
    Source = Json.Document(Web.Contents("url to firebase database")),
    #"Converted to Table" = Record.ToTable(Source)
    in
    #"Converted to Table"

[Anonymous]

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?

[mh2587]

https://community.powerbi.com/t5/Power-Query/Loading-firebase-database-to-Power-BI/td-p/127669

you can also check this thread as well

[mh2587]

https://hevodata.com/learn/firebase-power-bi-integration/#method1

you can follow these stips