cancel
Showing results for 
Search instead for 
Did you mean: 
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

@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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors