cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to connect Firebase DB in Power BI

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.

 

spadmanathan_0-1645794178389.png

 

5 REPLIES 5
Anonymous
Not applicable

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?

spadmanathan_0-1646058147282.png

 

spadmanathan_1-1646058232287.png

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
Super User
Super User

Get Data > Blank query 

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


Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/
Anonymous
Not applicable

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



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/

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

you can follow these stips



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.