Forum Discussion
get data source as excel but from URL
I try to get data source from excel, but excel is not on my file system but in url link www. when i try to do it i get error : " the microsoft.ace.oledb.12.0 is not registred on local machine . the 64 bit version of the access database engine 2010 access......"
Hi , Anonymous
Is the error message details similar to this：
"Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read 'XY_Create.mdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."If it is ,please download Microsoft Access Database Engine 2010 Redistributable on your machine and try it again:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- Greg_Deckler
Community Champion
Is the Excel file in SharePoint or something else, what exactly is that something else? A custom website, CMS, ?
What connector are you using?
not share point. public website with excel link - https://psa.gov.ph/sites/default/files/2019%20T1_1.xlsx
- nandukrishnavs
Anonymous I'm able to access the excel file using the web connector. You have to install the access database engine.
Refer to this link https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-access-database-errors
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
- v-easonf-msft
Community Support
Hi , Anonymous
Is the error message details similar to this：
"Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read 'XY_Create.mdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."If it is ,please download Microsoft Access Database Engine 2010 Redistributable on your machine and try it again:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. = Excel.Workbook(Web.Contents("https://psa.gov.ph/sites/default/files/2019%20T1_1.xlsx"), null, true)
try it- v-easonf-msft
Hi , Anonymous
Could you please tell me whether your problem has been solved?
If it is, please mark the helpful replies or add your reply as Answered to close this thread.Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
