Forum Discussion
Error with Schedule Refresh on Power BI Web
Hello, can someone assist me with this issue?
I'm trying to make one schedule refresh on Power BI Web, but, its given to me this error message below
| Data source error: | DataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: .. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Data. |
| Cluster URI: | WABI-BRAZIL-SOUTH-redirect.analysis.windows.net |
| Activity ID: | 4f9cb9fc-4062-4b6b-93ed-8eb4cb6a363e |
| Request ID: | d76c4512-8170-4d61-ba78-16af654ae0e0 |
| Time: | 2024-09-18 13:32:58Z |
I've already installed the Microsoft Access Database Engine 2016 64 bits on my device, and also, my power bi desktop is 64 bits, and the error persist,
The issue is only one Dashboard, I've another one's here and this error doesn't happen with then, only with this one.
The difference on this dashboard then the other one is, on this one I use the sharepoint folder to get the data to mde the analysis, and also the M language to process data.
Is something that I need to add on the M script?
Thanks for now
I've saved the file with the file Excel Workbook and I think that it worked, although I need to be sure that is not possible to do it if the file is with the extension "xlsb"
If not, do we heve some Microsoft article that is talk about it?
I tryng to found by myself, but without success.
Thanks!
13 Replies
I've saved the file with the file Excel Workbook and I think that it worked, although I need to be sure that is not possible to do it if the file is with the extension "xlsb"
If not, do we heve some Microsoft article that is talk about it?
I tryng to found by myself, but without success.
Thanks!Not saying that it is not possible, but it requires a legacy driver with big performance penalties and setup issues on gateways. Not worth the effort.
If at all possible do not use Access as a data source. It is not a good source for Power BI.
I've already installed the Microsoft Access Database Engine 2016 64 bits on my device,Not good enough. You need to do that on all gateway cluster members.
Ok, got it, but do you know what to do about it?
Also, I forgot to mention that the Excel file is with the extension xlsb
Thanks!
the problem is the same with accdb, xls and xlsb files.
Change your file type to xlsx or xlsm - that completely removes the issue.
