Forum Discussion
DebbieE
7 years agoCommunity Champion
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...
v-danhe-msft
7 years agoMicrosoft Employee
Hi DebbieE,
Based on my research, you could refer to below link, it seems encountered the same problems like yours:
Regards,
Daniel He
- DebbieE7 years agoCommunity Champion
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"