Forum Discussion

aurkmez's avatar
aurkmez
New Member
3 years ago
Solved

Load txt as table in powerquery

Hello everyone,   How would you load this txt as a table? I could transform only the Customer ID column but I need to divide the rest as well.  
Need Help
  • aurkmez's avatar
    aurkmez
    3 years ago

    I was able to solve this with some effort, if someone is curious I can send my .pbix file. Thanks!

m_dekorte's avatar
m_dekorte
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi aurkmez,

 

When you select the Source step, go to the View tab on the Ribbon and enable "Monospaced"

Do your column values align?

 

If not, please share a sample file