Additional columns from azure table to showing up

[rbenjamin]

I import data from a Azure Table Storage. 

I now add a new column to the table and go to refresh the data set in Power BI. The new colum does not show up and the data does not appear to be refreshing correctly.

If I uninstall and reinstall Power BI the new columns now show up.

Any ideas what is going on?

[nagpuresushant]

Try following below steps, it worked for me.

1. In Power BI Desktop, go to File -> Option and Settings -> Options
2. Under Global, clear cache for everything.
3. Close PBIX file and open it again.
4. Refresh data and go to Edit Query and those columns should be visible there.

[Anonymous]

i also had this problem.

if you click the advanced editor button, this will show you the underlying power query and here you can edit it manually to add in the column names you're after.

[Anonymous]

Hi @rbenjamin,

Can you provide more detailed information about this? I' m not so sure for your scenario.

>>If I uninstall and reinstall Power BI the new columns now show up.

Did you means the issue only appears on previous version and has been fixed on last version of power bi?

Regards,

Xiaoxin Sheng

[tiagonmas]

I have the same issue. The problem exists in PowerBI but also if trying to load data in Excel from an Azure Table. It seems it always looks for a cached table definition and it never updates the columns.

The only workaround I found until now was to move the data to a new table with a different name ...