Forum Discussion
Power Query - not recognizing "tab" in tab-delimited CSV files
Hello, I was working with Power BI 2019 and had no problems importing tab delimited files. However I was recently updated to 2021 (January). Now on the import process, the power query editor will ...
lbendlin
Super User
Super UserYou can omit the Columns= part entirely. It is there mostly to protect you from upstream changes (let's say you are usually getting 25 columns but all of a sudden the upstream system sends 25000)
Can you post a sanitized sample file? Are you sure your data is UTF-8 encoded?