Forum Discussion
Google Big Query & Schema Problem
Hi rrhutch,
>>If I preview the table in Big Query, it shows all of the various Itemizations fields, like in the schema shown in the first image.
It seems like you are review defined parameter list of your table instead of detail records.
>>Does anyone know why PowerQuery would not bring in the schema like it is showing in Big Query?
I think you need to find out where google store these defined parameters. If you direct select specific table, power bi will load detail data instead table structure description.
Regards,
Xiaoxin Sheng
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.
Did anyone figure this out? I am having the same issue. Thanks.
jason435 did you find any solution for this issue.
No I did not.
