Forum Discussion
Solved
Power Query from folder, from csv change to from tsv.
The Power Query I originally set up was from Folder, and collected from three csv files. These are now tab seperated values (tsv) and when I try to modify the query get a bunch of blank rows. Wha...
They both should use the Csv.Document function in your Transform Sample File query, and you should just have to change the delimiter in that function.
Pat
@RobRayborn
If you already set a connection with folder, you can just change the extent to txt(tab delimited), and simply refresh in power bi. Then right click the content to check tables.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.