Extract data as table format from website PBI

[colourfullife]

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

[Greg_Deckler]

@colourfullife 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.

[colourfullife]

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]

@colourfullife 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?

[colourfullife]

Hello @Greg_Deckler 

I extracted data using the funcion as picuture below.

can you expalin me how to chcek M code please?