The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi
Am connecting to Google Big Query which contains data sourced from Firebase. When I connect the nested fields are coming back without the necessary level of detail
I have tried both the Power BI Big Query connector and the Simba ODBC connector but they are both having the same issue.
I did find the following post but this requires work on the Big Query side. I have daily files that will need to be converted and it is not clear how I manage this process
https://www.inflexionanalytics.com/blogs/importing-unnested-data-from-bigquery-to-powerbi/
Is anyone aware of another solution?
Solved! Go to Solution.
Hello @JHob,
I would like to suggest that you check the JSON string and try to correct them as common JSON formats, then you can use the JSON connector to parse these texts and extract specific fields you want.
If you are still confused about how to do this, please share some dummy data from your receiving records (delete sensitive data parts) and share it here with the expected results and fields.
Next, we can test the encoding formula in this sample data.
Best regards
Xiaoxin Sheng
@JHob , can check how to handle JSON data, if that can help
https://www.youtube.com/watch?v=ipI6mrWLQKA
https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/?gclid=EAIaIQobChMI7Za92YSi6wIVFSQrCh0...
Thank you @amitchandak but the issue is more complicated.
The Google Big Query nested data format is not handled well by Power BI and the data is not available even when parsing the column
Please how did you resolve this?
Hello @JHob,
I would like to suggest that you check the JSON string and try to correct them as common JSON formats, then you can use the JSON connector to parse these texts and extract specific fields you want.
If you are still confused about how to do this, please share some dummy data from your receiving records (delete sensitive data parts) and share it here with the expected results and fields.
Next, we can test the encoding formula in this sample data.
Best regards
Xiaoxin Sheng
User | Count |
---|---|
160 | |
111 | |
96 | |
86 | |
75 |
User | Count |
---|---|
158 | |
136 | |
133 | |
81 | |
61 |