How to Import from a Web page with tabs on the table?

[BarryB75]

I hope you guys (and gals) can help.  I'm trying to import a table from a web page and only having partial success.  On the web page, the table has multiple tabs.  When I put in the url into power BI, it comes over as one table and I only get the first tab.  The url doesn't change when I click on the other tabs on the website table.  How do I get the other information (on the additional tabs) to download?

[BhaveshPatel · Accepted solution]

You can do this by following below guidelines.

!. Firstly create parameter ( List of Values) using Blank Query. This list will act as dynamic page no. in your Query.

2. Secondly, You need to replace the page no. in your Web.contents function with NumberToText function. 

This will give you all the tables in your webpage at one shot.

For Demo, Please refer to this BLOG for step by step process.