Forum Discussion
Helper IIIaccessing a file embedded on a web page
Thank you for all your help!
Helper IIII 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).
Helper IIIAnd here's confirmation that I'm running Office 365, 64 bit.
artemusMicrosoft Employee
Hrm.. I'm at a loss to what is happening here. I may be trying to load it in a different way since it is on the web.
Could you try:
- wrwillits
Had the same issues in PowerBI.
The crazy thing, though, is that I am able to access the data using Excel.
- wrwillits
And I only had to use the Web Connector in Excel.
- artemus
So, just to be clear:
= Excel.Workbook(Binary.Buffer(File.Contents("c:\MyDownloadFolder\PET_PRI_SPT_S1_D.xls")), null, true)
gave the same error in Power Bi, as this would indicate that the fact the document is loaded from the file system is what causes it to correctly load.
- wrwillits
No, it gave me the following error:
- artemus
Sorry, I mean, replace the path with the path to your downloaded file
- wrwillits
Sorry, my fault.
Here's what I get now:
- artemus
Alright, looks like you will need to install this package:
https://www.microsoft.com/en-gb/download/details.aspx?id=13255
Get the x64 version.
- wrwillits
I get the same message when I try to install the 64 bit version, even though my installed Office 365 is 64 bit:
- artemus
Ok... how about trying to install this one instead:
https://www.microsoft.com/en-us/download/details.aspx?id=54920
- wrwillits
I think we have finally figured out the issue! Was able to load the data into Power Query.
I still do not understand wehy I needed to load a new version of Access engine to make it work though.
- wrwillits
Thank you for all your help!