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: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Fixed width text in desktop

‎03-18-2016 05:12 AM

HI. I'm having trouble importing a txt fixed width file into the desktop. I know the field structure and width for each field, but I can't figure out how to separate the data bringing it into Power BI desktop.  

Message 1 of 2
2,068 Views
0
1 REPLY 1
ImkeF
Community Champion
Community Champion

‎03-18-2016 05:59 AM

You're lucky: Less than 3 weeks old 🙂  http://www.powerpivotpro.com/2016/03/power-query-fixed-width-magic/

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Message 2 of 2
2,057 Views

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

View All
Top Solution Authors
View All