Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Extract data as table format from website PBI

Hello All,

I need your help on extracting data from webisite.

I have a table like below.

 

when i extracted this table to excel it all become as column based data like below.

 

I want extract the data as the table setting that i created. is it possible? then please let me know 🙂

 

thank you!

CL

 

Need Help
Show and Tell

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Sorry, not quite getting what you want it to look like. Seems like it did a pretty nice job of extracting the data. Seems like you just need to configure a Matrix visual to recreate your website visual? Again, not entirely sure what you are asking.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello Greg_Deckler 

       

      I'd like to extract the data with the format that i built up on the report, as how it looks like in the web.

      is it understandable? 

       

      thank you,

      CL

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        4 years ago

        Anonymous That's unlikely to work out for you for a variety of reasons but sure, how are you extracting it right now? Are you using Power Query or something else? If Power Query, what connector are you using and what is your M code from Advanced Editor?