Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
powerbinewbie26
Helper I
Helper I

New column in web excel data not being pulled into powerbi

‎07-25-2023 10:33 AM

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.

Capture.PNG

Any help woudl be greatly appreciated! 

 

Message 1 of 4
191 Views
0
1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

‎07-25-2023 11:20 PM

Hi @powerbinewbie26 ,

 

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

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

Message 3 of 4
154 Views
3 REPLIES 3
BA_Pete
Super User
Super User

‎07-25-2023 11:20 PM

Hi @powerbinewbie26 ,

 

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

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Message 3 of 4
155 Views
powerbinewbie26
Helper I
Helper I
In response to BA_Pete

‎07-26-2023 04:53 AM

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

Message 4 of 4
140 Views
powerbinewbie26
Helper I
Helper I

‎07-25-2023 10:33 AM

@BA_Pete @rubayatyasmin @AlienSx 

Message 2 of 4
190 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All