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.
