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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AP_BI
Frequent Visitor

Power Query does not recognize subsequently added columns in source file

Dear community,

 

I get my report from a connected .xlsm from a sharepoint. I had to add 3 columns to the basic data of the .xlsm file. Unfortunately the columns are apparently not recognized in PowerBI after the refresh. But I need these 3 columns urgently for the evaluation. I have tried many hours but I can't find an appropriate solution for the problem on my own or in the forum. 

 

Can anyone please help me?

Thanks a lot in advance,
Andi

 

1 ACCEPTED SOLUTION

Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@AP_BI 

Can you open the file directly from SharePoint and check if you can see those newly added columns?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

AP_BI
Frequent Visitor

Hello @Fowmy 

yes, that works perfectly fine. I tried it with Sharepoint Folder as well as Excel offline source and there is no problem with the added columns. 

Probably I have to change some of the applied steps (refer to the picture). As you can see the Sharepoint has lots of different files. I filtered for .xlsm as it is the only file I want to use. After that I removed top rows. But the last 3 columns from source data are missing.

AP_BI_0-1595855486467.png

 

Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors