Forum Discussion
Data Download from Website
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 wo...
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
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,
- Is there any authentication when login the report site before running the report?
- 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.
Hi Eric,
- Yes there is an authentication to access the data before running the report.
- 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 wrote:
Hi Eric,
- Yes there is an authentication to access the data before running the report.
- 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.
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.
