cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Refresh failed (no problem with PBID)

Hello,

I got a problem when I try to refresh the datas with PBI on line.

 

Here is the error :

Erreur de source de donnéesExcel Workbook: 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 is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
URI du clusterWABI-NORTH-EUROPE-redirect.analysis.windows.net
ID d'activitéef0ca095-b406-4382-a495-70db5cc12e3a
ID de demanded3e07c09-ad77-a387-b858-b7fed099996c
Heure2016-09-21 12:48:45Z
 
There is no problem when I refresh it with PBIDesktop.
There is no problem when I publish it from PBIDesktop.
I would like the report refresh itself each hour. It doesn't work and I don't know why.
 
I got many report and it is the only one which the refreshment is failed.
 
Does anybody know the issue?
 
Thank you all,
1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

Hi @Anonymous,

Do you connect to .xls Excel file and refresh it in Power BI Service? If that is the case, refreshing against a .xls file is not supported. As stated in this article, 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 250 MB.

To work around the above issue, you can change Excel file form type .xls to .xlsx, then you are able to refresh the dataset in Power BI Service.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft
Microsoft

Hi @Anonymous,

Do you connect to .xls Excel file and refresh it in Power BI Service? If that is the case, refreshing against a .xls file is not supported. As stated in this article, 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 250 MB.

To work around the above issue, you can change Excel file form type .xls to .xlsx, then you are able to refresh the dataset in Power BI Service.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Ok,

You're right! It's working with xlsx files.

 

Thank you very much!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors