Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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
@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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |