Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Dec 01, 2023

Power Query/PowerBI Extract some values from complex CSV

Dear Experts,                   From attached file, I need to create a Report like below:- Each of the Report entry has following parameters:- So from "TB Top " we need to extract "Frame" & "SubFN...
BI & Data Analysis
Power BI
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Feb 14, 2024

    Hi anupambit1797 

     

    I tried to use this calculator again, but seems not working, attached is the raw txt file

    As I earlier mentioned your initial call for help required significant analysis, before putting in place a non-trivial query that was based on the file you shared at that time. So, IF the new text file isn't formatted exactly the same, new analysis + query update (or totally new one) are probably required

     

    While changing the source, it's giving an err:-
    Your screenshot doesn't show the error in Power Query but it seems obvious you have to update the file path in Excel as it still points to my PC folders' structure

     

    That's all I can do for now (didn't download your file) as my PC died a few days ago and the new one hasn't landed yet

  • anupambit1797's avatar
    anupambit1797
    Iron Contributor
    Feb 14, 2024

    HiLorenzo 

                  Greetings!

                  I tried to use this calculator again, but seems not working, attached is the raw txt file.

     

    While changing the source, it's giving an err:-

    Can you please help on what wrong I am doing?

     

    Thanks in Advance,

    Br,

    Anupam

Resources