Forum Discussion
DAXRichArd
Resolver I
6 years agoQuery data from unstructured text file (*.txt)
Hello, As usual I searched the forum first as well as youtube vids before posting a request for help. Notes: Using Power BI Report Server (PBI RS). Unstructured text file with 8 columns. The...
- 6 years ago
You should have "Split Column by Positions" - this is a very old Split transformation and RS should have it.
If not, the Table.SplitColumn is surely available even if not via the UI.
= Table.SplitColumn(#"Filtered Rows", "Image", Splitter.SplitTextByPositions({4, 9, 20}), {"Image.1", "Image.2", "Image.3"})That is splitting the table #"Filtered Rows" (the previous step) column [Image] into 3 new columns (Image.1/2/3) at postions 4, 9, and 20.
With that info you can manually create your step if that menu option isn't there.
- Anonymous6 years ago
Hi DAXRichArd
Try selecting the column first. In the PBI RS the ribbon changes quite a bit depending on the context.
Kind regards,
JB
Anonymous
6 years agoNot applicable
Hi DAXRichArd
Try selecting the column first. In the PBI RS the ribbon changes quite a bit depending on the context.
Kind regards,
JB