Not all columns expanding because first 1000 fields are null

v-qiuyu-msft

Hi Qiuyun Yu,

we are facing the same problem in querying data from Marketo using REST API.  If the first few records in a column return NULL, the entire column is droppped without any warning.

As Anonymous mentioned, one work around is to type in all the known columns specifically. However, this presumes knowing what those columns are (which means I need to explore data outside of PowerBI).

Any suggestions on how to prevent PowerBI from dropping columns with partial NULL records.

Thanks,

Kunal