Forum Discussion
Solved
JSON data from Google Big Query not interpreted correctly once extracted in Power BI
Hello guys, So I am working on this piece of work where I am trying to fetch Google Big Query data in Power BI, however when I do that in normal tabular format, it comes out to be somewhat gibber...
Finally I reached to a conclusion here where I am Unnesting the columns in Google Big Query, saving them as views and then consuming them in Power BI.
Prerequisite is that you have some background knowledge of writing queries in Google Big Query.
Some information on the queries can be found here:
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#unnest_operator
Hi PC2790
Please check whether there are other tables in the Navigator Pane. Maybe some tables contains proper data.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution . Really appreciate!