Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
CamJohnston
Frequent Visitor

New Columns added to excel spreadsheet now appearing in Power BI after refresh

As the subject says, 2 new columns added to the spreadsheet which is serving up the data to Power BI are not appearing after refreshes to the data. Other explanations talk about re-importing the model or editing the supporting power query. In both cases, I have yet to find how to get to that functionality in either the desktop or web Power BI client. 

I would be grateful for any insights or help 🙂

1 ACCEPTED SOLUTION
BI_Climber
Regular Visitor

Hi @CamJohnston,

 

what you could try is to import the same excel file into PowerBi again and see if the added lines appear after a completely new import.

 

To me, your screenshots and description look like you are not actually connected to the excel file at all but a Power BI dataset stored in the Power BI service.

Because of this, you cannot transform the data (i.e. grayed out).

 

Importing the Excel file from scratch should show you if this is the case.

 

Hope this helps.

View solution in original post

3 REPLIES 3
BI_Climber
Regular Visitor

Hi @CamJohnston,

 

what you could try is to import the same excel file into PowerBi again and see if the added lines appear after a completely new import.

 

To me, your screenshots and description look like you are not actually connected to the excel file at all but a Power BI dataset stored in the Power BI service.

Because of this, you cannot transform the data (i.e. grayed out).

 

Importing the Excel file from scratch should show you if this is the case.

 

Hope this helps.

amitchandak
Super User
Super User

@CamJohnston , Ideally in the new version, it should add and remove columns just by refreshing. But still, you can do it manually, refer to this video

https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@amitchandak Thanks for the quick response. I get what you are saying but as I said previously I do not see how to get there i.e Power Query

When I click on transform here is what I get. No option to get to Power Query

 

Screenshot 2023-01-06 145502.png

 

When I click on data source I end up in the hub and here

Screenshot 2023-01-06 145609.png

 

Thank you for your help and getting this solved!

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

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