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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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

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

Where do i see that option.

  • vcastello's avatar
    vcastello
    Icon for Resolver III rankResolver III
    9 years ago

    Hi drallam

    Try ....

    1. Obtain Data
    2. Web

    Insert the url there

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    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.