none
Importing Azure table storage data into Excel using Power Query isn't loading all the columns

    Question

  • Hi,

    I have requirement to consume Azure table storage data into Excel using Power Query. When I import Azure table storage data into Excel I am not getting all the columns which present in Azure table instead only columns which present in first row. I created these Azure table with dynamic entity so columns differ on each row.

    Example:

    1st row column names: col1 col2 col3

    2nd row column names: col1 col2 col3 col4

    Power Query takes only first row columns and loads data only for those three columns for all rows.

     Is there a way to download all the columns which present in Azure table?. When I try using OData URL in browser I am able to load all the columns.

    Regards,

    Jayapal.

    Tuesday, September 22, 2015 1:25 PM

Answers