New column added to Cosmo DB collection not appearing in Power BI Desktop table.

[BRVL]

A new column is not showing into Power BI from the data source ( Cosmo db).

Pushed an update which added a new column into my cosmo db collection, the column is stored as a record which should expand into two columns. 

I've tried refreshing the data, adding the column manually in Advanced Editor, clearin cache, resetting credientials and viewing the opening the table in a new file.

However, this column is still missing. Any thoughts? 

Thanks

[Anonymous]

Hi @BRVL ,

What is your connection mode? Can you see the new column in the Navigator page? Or did you get an error message when you refreshed?

I cannot reproduce your issue. When I use import mode import data, the new column would appear after I refresh the data.

I have also found a similar post, please refer to it to see if it helps you.

Refresh powerBI data with additional column 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BRVL · Accepted solution]

Thank you for your advice, but I've managed to resolve the issue myself. I just need to manually add the column in advanced query and mess around with the sort to get the option to expand this column into two.