Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.