Import table from website with Power Query

[Forloveofgod]

Hello there,

I want to take the 4 tables I marked in the screenshot below.

"ThisWebSite"

I didnt able to see tables at my Query Tab.

Thanks for helps.

 

[jdellasala]

It took a very long time for Excel to connect, and then it only found 3 tables, and none of them were the ones in the first screenshot - same as you found.
I used Power BI's Web Import with more success, but the main query didn't work and had to be deleted, but pasting the query into Excel didn't work (mostly), however Power BI did find 14 tables.
What you could do is use Power BI to import the tables you want, and then in the Data View copy the table and paste it into an Excel Worksheet.
I'll add that the one query I attempted to copy and paste into Excel failed miserably, it did bring in the 3 tables I selected in a very strange way, and not necessarily what I was looking for! You might have better success, but I wouldn't trust it. The two Web Imports are VERY different, and the results of the Power BI queries in Excel look very sketchy and wouldn't refresh anyway.
Good luck!

 

[Forloveofgod]

and the results of the Power BI queries in Excel look very sketchy and wouldn't refresh anyway.

Thats the problem, I did take tables with VBA but they are not refreshable.

There is about 400 different similar webpage I want to take 4x400=1600 tables at different sheets in same worksheet.

I have to find a way to get refreshable tables.

Thank you anyway.