Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Rgs,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.