Error with Schedule Refresh on Power BI Web

[amaral_diego]

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

[amaral_diego · Accepted solution]

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!

[lbendlin]

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.

[lbendlin]

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.

[amaral_diego]

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!

[lbendlin]

the problem is the same with accdb, xls and xlsb files.

Change your file type to xlsx or xlsm - that completely removes the issue.

[amaral_diego]

I've tried that already, but if we do that the file is "broken" and we can not opened him.

[lbendlin]

not just rename the file - change its format ("save as")

[amaral_diego]

I've changed the file format here, the way you said, but the error to refresh persist, but now the error message is different, is this one below

Data source error:	DataFormat.Error: The specified package is not valid.. . 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:	4d4a90b6-3578-4eef-8cbc-7f849cfc769c
Request ID:	dd739b2e-79f5-40f2-9c20-87a5e051b5a1
Time:	2024-09-20 14:29:22Z

Do you know what could be?

[lbendlin]

does the .xlsx work on the Power BI Desktop?

[amaral_diego]

Didn't work with .xlsx file, I've tried this way and return the message that I've insert here before.
I'm using one M scrip does this could be the issue?

[lbendlin]

not usually.  Please describe in more detail what you are trying to accomplish.

[amaral_diego]

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!

[amaral_diego]

I need to configure the schedule refresh on this dashboard, but is return me this error below

"DataFormat.Error: The specified package is not valid.. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Data."

I have two other panels here, both are working and refreshing properly, only this one is not working, the only difference on this is that the data is coming to one SharePoint folder

I've changed the file data to xlsx,
I've the gateway installed on my device,
Although the issue persist, only on this dashboard