Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 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/116592 

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. 🙂 

Need Help

3 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      "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."