Added New Azure Table Storage but Power Query Editor not finding columns

[DebbieE]

I have added another Table to my Azure Storage folder. In Power Query Editor I click on Recent Sources and Choose my Azure Storage container.

There is now a new table in here so I choose this new table and OK

I click on the button on Content to add the content  but it says No columns were found.

I can see the column in Azure Table Explorer. i cant figure out how to resolve this. If I try adding a new source the exact same thing happens

Any help would be really appreciated

Debbie

[v-danhe-msft]

Hi @DebbieE,

Based on my research, you could refer to below link, it seems encountered the same problems like yours:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-lt-ColumnTitle-gt-of-the-table-...

Regards,

Daniel He

[DebbieE]

Thank you,

I had to go into another Query. Copy and paste and alter to get my data up

let
Source = AzureStorage.Tables("tstore"),
dataset = Source{[Name="dataset"]}[Data],
#"Expanded Content" = Table.ExpandRecordColumn(dataset, "Content", {"Tweettext"}, {"Content.Tweettext"})
in
#"Expanded Content"