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.

       

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

        Hrm... I wonder why it works if you download it locally first? You are sure if you load it locally you do not have this problem?