Forum Discussion
Unable to add Column from SharePoint Data
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 adde...
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.
"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."
Anonymous,
Can you provide your M code?