Unable to add Column from SharePoint Data

[Anonymous]

Hi all,

Problem: 

- I have updated a CSV file (export from ServiceNow) where a new column has been added (last column). However, when I refresh my dataset in Power BI, the new column is not added to the table.

I've looked for a solution to my problem and I haven't been able to resolve thus far. 

https://community.powerbi.com/t5/Desktop/Add-a-new-column-to-the-existing-data-set-and-refresh/m-p/1... 

This did not work as I am presented with an error upson saving that says Expression.Error: "The column 'problem_id' of the table wasn't found"

I do not see a column count at the top of the advanced editor, so I am unsure of how to increase the number of columns. 

I'm open to suggestions please and thank you. 🙂 

[DataInsights]

@Anonymous,

I tested this with a csv file and got it to recognize the new column by increasing the Columns argument of the Source step. You can see this in Advanced Editor as well.

My initial csv file had two columns. After adding a third column to the csv file, I change the Columns argument of the Source step from 2 to 3 and it imported the new column.

[Anonymous]

"I tested this with a csv file and got it to recognize the new column by increasing the Columns argument of the Source step. You can see this in Advanced Editor as well." As I mentioned in my first post, "I do not see a column count at the top of the advanced editor, so I am unsure of how to increase the number of columns."

[DataInsights]

@Anonymous,

Can you provide your M code?