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: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
agd50
Helper V
Helper V

Cleaning Excel Data Question

‎10-24-2023 08:54 PM

Any advice for cleaning Excel data that doesn't translate well for Power BI? 

(Lots of colored cells, Subheaders that are hard to edit, etc) 
Flat vs Wide perhaps? TIA

Labels:
Message 1 of 2
297 Views
0
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

‎10-24-2023 09:41 PM

Hi @agd50 
Most of the cleaning manipulations are possible with the power query itself, take a look at the linked guide:
https://www.youtube.com/watch?v=AWcmiyra7qs

Other ETL tools that you can use: excel, pandas, data factory etc...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Message 2 of 2
270 Views
1 REPLY 1
Ritaf1983
Super User
Super User

‎10-24-2023 09:41 PM

Hi @agd50 
Most of the cleaning manipulations are possible with the power query itself, take a look at the linked guide:
https://www.youtube.com/watch?v=AWcmiyra7qs

Other ETL tools that you can use: excel, pandas, data factory etc...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Message 2 of 2
271 Views

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All