Forum Discussion

powerbinewbie26's avatar
3 years ago
Solved

New column in web excel data not being pulled into powerbi

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! 

 

  • Hi powerbinewbie26 ,

     

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

     

    Pete