Forum Discussion

DAXRichArd's avatar
DAXRichArd
Resolver I
6 years ago
Solved

Query 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...
  • edhans's avatar
    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.

  • Anonymous's avatar
    Anonymous
    6 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