New column in web excel data not being pulled into powerbi

[powerbinewbie26]

Hi there! 

Hoping someone can help me out, I have a dashboard that uses SharePoint Live excel documents (my data source was added as a Web excel workbook). I've added a new column in two of my original excel documents and have refreshed the powerbi data sets but the column is only being pulled into one of them even though both were done the same way. 

Many articles say to set Columns=Null to resolve, but with a web workbook this doesn't come up. Attached is the advanced editor I have.

Any help woudl be greatly appreciated! 

[BA_Pete · Accepted solution]

Hi @powerbinewbie26 ,

Silly question I'm sure, but have you included your new columns within the #'Removed Other Columns" step at the end?

Pete

[powerbinewbie26]

Lol silly but accurate - i think this was the fix - thank you so much! 🙂

[powerbinewbie26]

@BA_Pete @rubayatyasmin @AlienSx