Data Download from Website

[drallam]

Hi,

I usually run a report on a website and download that as a excel file. I can see the table in the webpage. How do i connect that website to Power BI. I tried copying in the URL but doens't work. I'm I missing any steps?

Thanks

[TylerKolota]

If you have Power Automate Desktop and access to a spare computer or virtual machine, then you could try the set-up I explain here:

• https://youtu.be/ONl7B9-9lPU

[Eric_Zhang]

---

@drallam wrote:

Hi,

I usually run a report on a website and download that as a excel file. I can see the table in the webpage. How do i connect that website to Power BI. I tried copying in the URL but doens't work. I'm I missing any steps?

Thanks

---

@drallam

My guess is that probably you can't simply get the data from the "table" via the "get data"->"other"->"web" with the report site url. Two questions,

1. Is there any authentication when login the report site before running the report?
2. What is  the underlying request when clicking on "run the report"? You could probably get data from the actually request url(In Chrome, press F12 to enter developer console, select network tab and then click "run the report" button) instead of the report page.
   

[drallam]

Hi Eric,

1. Yes there is an authentication to access the data before running the report.
2. The idea is to exprot that data to an excel file after running the report. And I load that to power BI. I was wondering if there a way to directly pull that data.  Or what would be  the ideal workflow to do it would be the greater question.

[Eric_Zhang]

---

@drallam wrote:

Hi Eric,

1. Yes there is an authentication to access the data before running the report.
2. The idea is to exprot that data to an excel file after running the report. And I load that to power BI. I was wondering if there a way to directly pull that data.  Or what would be  the ideal workflow to do it would be the greater question.

---

@drallam

I'd say it depends on your report app. If you can get the correlated API loading data, you may call that API directly to get data in Power BI.

[Greg_Deckler]

Try entering the URL into a Web query and using the visualize page option to select the table?

[drallam]

Where do i see that option.

[Greg_Deckler]

Get data | Web. After you enter the URL you should get a dialog with the Document and any tables listed. You can then click on the "Web View" tab at the top to see the web page and it should highlight the tables and allow you to checkmark the ones that you want to import.

[vcastello]

Hi @drallam

Try ....

1. Obtain Data
2. Web

Insert the url there