Forum Discussion
Helper IIIaccessing a file embedded on a web page
Thank you for all your help!
Helper IIIAnd here's confirmation that I'm running Office 365, 64 bit.
Microsoft EmployeeHrm.. 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!