Table Storage Data Source Caching Issue

[tbithell]

After making changes to an Azure Table Storage table, specifically adding new columns, those columns do not show up when I edit my query in power bi desktop.  Even after deleting the table from the query and readding it, the column changes are not reflected.  The only way I've been able to get around this is by going into the advanced editor and changing the line that starts with:

#"Expanded Content" = Table.ExpandRecordColumn(... 

and making the column changes there.  

Seems like it is some sort of caching issue. 

[Anonymous]

@tbithell,

Please go to File->Options and Settings->Options->Data Load, then clear cache in Power BI Desktop. This way, you should be able to get new columns without changing line in Advanced Editor.



Regards,

Lydia