Forum Discussion
rrhutch
8 years agoHelper II
Google Big Query & Schema Problem
I am connecting to a table I have in Google Big Query. However, the data coming into PowerQuery doesn't match the schema showing in Big Query. Following is a sample of the schema in Big Query for the...
rrhutch
8 years agoHelper II
From some other research, it looks like the issues is related to tables that are nested or has repeated rows. Google Big Query knows how to interpret the schema of those tables and display them as a flattened table. Even though PowerBI has a connector to Big Query, it doesn't appear that PBI knows how to handle those schemas.
So if anyone has figured out how to do this between Google Big Query & PBI, I would appreciate to know how.
jason435
6 years agoHelper II
Did anyone figure this out? I am having the same issue. Thanks.
- cld4engtest6 years agoNew Member
jason435 did you find any solution for this issue.
- jason4356 years agoHelper II
No I did not.