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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Power query

Hi, I am connecting a sharepoint folder to Power Query where I get reports uploaded every morning. 

 

All the reports have the first 10 rows that I do not need as it is just a broadcast data. I can delete the first 10 rows at the top but when the reports are joined below, moving from one date to another I get an error. 

 

How can I make the reports that get uploaded every morning to automactically delete the top 10 rows?

 

Aziza_0-1613060711412.png

 

Thank you very much

 

 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

Go to the Transform Sample query step. That is for 1 file, but it is processed for every file. 

edhans_0-1613061393603.png

Use the Remove Top Rows and select 10 in that query.

 

Then when the files are combined, they will all start with row 11.

 



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
edhans
Super User
Super User

Glad to help. That Transform Sample Query is a bit hidden at first, but once you understand what gets applied to each file one at a time vs what you should do after they are all combined it gets easier.



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
edhans
Super User
Super User

Go to the Transform Sample query step. That is for 1 file, but it is processed for every file. 

edhans_0-1613061393603.png

Use the Remove Top Rows and select 10 in that query.

 

Then when the files are combined, they will all start with row 11.

 



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
Anonymous
Not applicable

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors