Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
a68tbird
Resolver II
Resolver II

Web Scraping - Web.BrowserContents / Html.Table Errors

Hello All -

  I managed to create a PowerQuery in PowerBI to scrape the contents of a webpage, and it does exactly what I need it to do, except that I'm realizing it would better suit me if I was doing this in Excel (I ultimately want the info in a spreadsheet for my use).  However, copying the query over to Excel produces errors - notably a couple of expressions that aren't recognized: Web.BrowserContents and Html.Table.  I changed Web.BrowserContents to just Web.Contents and that was fine, but I'm not sure what to replace Html.Table with to make this work.  Most of the time, queries are interchangeable between Excel and PBI, but it seems using Web as source produces different results.  Any easy workarounds, or will I have to rebuild my query from scratch?

 

Thanks

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@a68tbird , not very clear. Create a table in power bi and copy-paste the table from power bi (Data view) to excel

https://www.youtube.com/watch?v=1_XlyzV-PcY

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@a68tbird , not very clear. Create a table in power bi and copy-paste the table from power bi (Data view) to excel

https://www.youtube.com/watch?v=1_XlyzV-PcY

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.