Forum Discussion

wrwillits's avatar
wrwillits
Icon for Helper III rankHelper III
6 years ago
Solved

accessing a file embedded on a web page

Can I access a file throught Power Query that is embedded on a web page?    I am trying to set up a link to an Excel file that is embedded on a web page. I need to link to the historic and current ...
Need Help
  • wrwillits's avatar
    wrwillits
    6 years ago

    Thank you for all your help!

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi wrwillits 

As tested, i can connect to this page with "Web" connector, with some transformations in Power query, it is possible to get data as below

Then add to a matrix, it shows as below:

But it doesn't update newest data to Power BI as i change the "period" from the web or any data updates there.

I think we may find a API for that web page and use it in Power BI.

I will update my answer as soon as i find the solutions.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • wrwillits's avatar
    wrwillits
    Icon for Helper III rankHelper III
    6 years ago

    Hi Maggie,

     

    Thanks for your reply. As you will see in my response to Artemus, I can't connect to the file using the Web connector in PowerBI because it's telling me that I don't have the proper "Access Database Engine 2010 Access Database Engine OLEDB", enen though I have the latest version of Office 365 installed (64 bit). 

     

    Also, I would be very interested in an API if it is available.

     

    Thanks,

     

    Warren

    • artemus's avatar
      artemus
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      Web.Contents is a pretty core function in Power Bi. You can't do much without it.

       

      When exactly do you get this error? Can you create a blank query and copy/paste the query I posted previously?

      • wrwillits's avatar
        wrwillits
        Icon for Helper III rankHelper III
        6 years ago

        I get the same error message.