Forum Discussion

drallam's avatar
drallam
Helper II
8 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 work. I'm I missing any steps?

 

Thanks

Need Help
Tips and Tricks

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

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

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    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's avatar
      drallam
      Helper 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
        Microsoft 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.