Forum Discussion
Helper IIIaccessing a file embedded on a web page
Thank you for all your help!
Microsoft EmployeeSo, 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.
Helper IIINo, 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!