Forum Discussion

drallam's avatar
drallam
Icon for Helper II rankHelper II
9 years ago

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...
Need Help
Tips and Tricks
drallam's avatar
drallam
Icon for Helper II rankHelper II
8 years ago

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's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
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.