Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a regular export from SAP that is in .txt format that I need to pull into Power BI. A new file gets emailed everyday, and a Power Automate flow converts it from HTML to .txt, and puts it in a sharepoint with all the previous files. The conversion is working perfectly, I have ruled that out as the issue, but there is a problem where one entry is getting combined with several others. Basically, Power Query ignores the pipe delimiters on the same entry everyday. Here is a screenshot of the cell that I am talking about:
All of that is in the same cell, despite the delimiters. I have discovered that there is a single quotation mark at the beginning of this in the file:
I am wondering how I can get Power Query to ignore quotes entirely, and split based on pipes all the time.
Hi @crobson29 ,
Replace single quotation mark with blank and then apply delimiter.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.