Forum Discussion
Added New Azure Table Storage but Power Query Editor not finding columns
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
2 Replies
Hi DebbieE,
Based on my research, you could refer to below link, it seems encountered the same problems like yours:
Regards,
Daniel He
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"
