Power BI service is not bringing new columns after scheduled refresh from source file automatically

[commercial_user]

I have a sharepoint excel file that is stored on a teams site. Power bi connects to the source file using the sharepoint folder connector. The file is a simple table with four columns and ten rows.  When a fifth column is added to the spreadsheet by the user and saves the the file,  (with the new column) added into the excel file. 

Now in the Power BI workspace the newly added column is not updating into the dataset table. 

Is this a known issue or is this more of limitation of the design for automatically refreshing?

The only work arounds is having to manually refresh from the m query (transform data tab) and publish the report from the desktop application into the workspace for the new column to show up in the dataset.

The power bi refresh has no issues adding rows to the underlying dataset but when a new column is added there seems to be an issue. 

[audreygerred · Accepted solution]

Hello! Refreshing in service simply refreshes the model as you published it. Adding a new column is a change to the model schema. To do this, open your pbix and refresh (this will bring the new column in if it an xlsx) then re-publish. Refreshing in service will add in new rows, not new columns.