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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Pipe to Column not properly Working

Hello, 

 

Im having some problem to import SAP Data into PowerBI.

For a few lines, the Pipe "|" to Column is not doing it correctly.

 

This is the advanced editor line responsible for importing the file:

Source = Csv.Document(File.Contents("C:\2018.7-S032.txt"),[Delimiter="|", Columns=27, QuoteStyle=QuoteStyle.None]) 

 

The problems is displayed below.

 

Pc1.png

 

Rgs,

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @RomuloBarbieri,

 

Would you please share a screenshot about how the data stored in C:\2018.7-S032.txt file? And clarify what's your desired results in Power BI desktop. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info