Forum Discussion

qwaiti273's avatar
qwaiti273
Regular Visitor
9 years ago

Step by Step process for loading Firebase Database to power bi

i need to extract data from firebase database to power bi..i would like to know the step by step process with the images ...i would highly appreciate ur help
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

qwaiti273,

Click “Get Data->Blank Query” to add a new blank query in Power BI Desktop, then paste the following code in Advanced Editor and expand columns in Query Editor.

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


There are some similar threads for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/Loading-firebase-database-to-Power-BI/td-p/127669
http://community.powerbi.com/t5/Desktop/A-bit-more-advanced-JSON-to-Power-BI/m-p/130000#U130000

Regards,
Lydia