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!

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?

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

        I have no problems loading it locally. I've been using the data in the below BI model for the past several months (downloading it manually each moth and then refreshing the model).