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 adde...
Need Help
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."

     

     

    • DataInsights's avatar
      DataInsights
      Super User
      4 years ago

      Anonymous,

       

      Can you provide your M code?