Which option do you rather choose?
If I click import then all 5GB dataset is downloaded?
How it work in details?
If I create custom field group then its always nested on 1st level:
And then how to load these records as a flat table? I know about adding ?flatten but I see that sometimes it does not work ....
Hi @michael_soprano, you can try this. Click on advanced option and write your query to fetch all columns or few columns that you need. I generally use ?FLATTEN in the Database option, and it works perfectly for me.
@tylerkrause thanks for response!
You request data from RTCDP or Data Lake?
I have really simple schema like that:
(its dummy data for demo purposes)
However the result in Power BI is like that:
Tried both import and directquery. Do you any hints?
Hi @michael_soprano, you can try this. Click on advanced option and write your query to fetch all columns or few columns that you need. I generally use ?FLATTEN in the Database option, and it works perfectly for me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
