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!

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).

       

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

        And here's confirmation that I'm running Office 365, 64 bit.