Forum Discussion
JSON data from Google Big Query not interpreted correctly once extracted in Power BI
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
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