Unnested Data connection from Google Big Query with incremental refresh (query folding)

[Namrata_Das_CLR]

Hi,

I have large data sets in google big query in a jsonPayload column, now i want that data to be unnested and loaded in power bi with supporting query folding so i can apply incremental refresh.

while trying to connect the format is getting changed and i am not even able to parse it (even knowing parsing will break query folding still i tried) 

Can anyone please help me how i can execute it, i am stuck in this from last 5 days.