Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Not all columns expanding because first 1000 fields are null

Wondering if there is a way to expand ALL columns from a Json.Document(Web.Contents...) => Table.FromList source when some columns don't have data in the first 1,000 rows.    I'm aware of methods s...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Anonymous,

 

I didn't see the limitation in Table.FromList() restrict blank columns. Regarding your question, would you please share some sample data from our to test?

 

Best Regards,
Qiuyun Yu

  • kunaly's avatar
    kunaly
    Regular Visitor
    8 years ago

    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  

    • AishwariyaV's avatar
      AishwariyaV
      Icon for Helper IV rankHelper IV
      6 years ago

      Hi,

      Is this problem solved? Is there any solution?

    • PBILover's avatar
      PBILover
      Icon for Helper V rankHelper V
      6 years ago

      Hey did you got any solution on this?