failed to refresh

[Maz_0102]

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: https://go.microsoft.com/fwlink/?LinkID=285987.

I have already downloaded and installed access database engine and it mateches the same bit bersion as my pbi installation (64 bit)

any advice please from anyone?

[Anonymous]

Hi @Maz_0102 ,

"Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. Some features described in this article are only available in later versions of Excel."

Please change your file extension from xls to xlsx.

During our investigation, we found some solutions provided by other users：

“What we found out, is that a user has opened an Excel file with LibreOffice or OpenOffice Calc, and left a lock file:

.~lock.filename.xlsx#

just beside the XLSX file, that PowerBI data gateway was reading as datasource was refreshing.

Simply deleting this lock file was enough for PowerBI data gateway to successfully continue refreshing the data source.”

For more information，you can refer to this 

If these workarounds don't work, we also found a similar problem in Power BI Idea. You can vote for it .

 Best Regards,
Community Support Team _ Caitlyn

[Maz_0102]

@Anonymous thank you so much, you are a star!

Can you help me with another thing please?

I am trying to do a count if function on a column but not sure how

I have a status column which consists of approved, declined and submitted

i want to count the values in the in that column excluding declined 

please can you advise