Connect Firebase Realtime Database to Power BI

Connect Firebase Realtime Database in Catchr using the database URL and service account JSON, then select the first-level node containing your records. In Catchr’s Power BI query builder, select record keys and consistently typed fields and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping the selected node and whether the returned rows are current snapshots clear in the model.

No. This source reads Firebase Realtime Database records. Cloud Firestore is a separate database, while Firebase Analytics contains app measurement events. Choose the connection and extraction route for the product storing the data you need. Loading Realtime Database rows into Power BI does not also import Analytics events or Firestore collections.

You need the URL of your Realtime Database instance and a service account JSON key with access to that database. A Firebase web API key alone is not sufficient for this Catchr connection. Ask the person managing your Firebase project to provide the correct service account credentials, and enter them in the Catchr connection form rather than in report text or a shared spreadsheet.

Place comparable records under a first-level node, such as orders with one child record per order. Keep field names and value types consistent across those records. Catchr infers columns from a sample and flattens nested objects containing scalar values; arrays are not expanded into report columns. If each order contains a list of items, prepare a separate item-level collection when you need item-level charts.

Catchr discovers fields from a limited sample of records in the selected node. A field absent from that sample may not appear, and mixed value types can cause a field to be treated as text. Check that the selected node contains populated, similarly structured records and that numeric values use a consistent type. Arrays need to be reshaped into records or scalar fields before reporting.

The Realtime Database name describes Firebase application synchronization. Catchr reads records when requested; importing that response into Power BI does not create a live database subscription. Publish the imported model and configure scheduled refresh if needed. Check the source update time and the model's last successful refresh separately when a recent change is missing.

You can report on historical records that your database still contains. The connector reads the current contents of the selected node; it does not reconstruct deleted records or earlier versions of overwritten values. Store dated events or snapshots when you need trends over time, and use an appropriate date field in your report. A current balance field by itself cannot show what the balance was last month.