Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Cmuglioni
Frequent Visitor

Update error message - PowerBi in Excel

Hi Everyone. I made a report in Excel that is connected directly to a data base in PowerBi in a Workspace.

 

I am getting everytime this error message:

 

Cmuglioni_0-1644586033861.png

Translate: The database driver does not include necessary capabilities and cannot be used with Excel. Contact your database administrator or driver vendor.

 

Also, sometimes, I am getting this error message as well:

 

Cmuglioni_1-1644586469215.png

My dax formula for Cajas N-1 is the following:

 

Cajas N-1 = CALCULATE(SUM(Inventario[Cajas]),DATESBETWEEN(Calendario[Fecha],Date(Max(Calendario[Año])-1,FORMAT(MIN(Calendario[Fecha]),"mm"),FORMAT(MIN(Calendario[Fecha]),"dd")),EDATE(MAX(Calendario[Fecha]),-12)))
 
(I am forcing the Sameperiodlastyear because I had some troubles with the time functions)
 
Sometimes I am getting this message error as well:
 
Cmuglioni_2-1644586760515.png

 

Additional Information: I update my Analyse in Excel tool to the last version.

 

Does anyone have an idea how I can fix these errors?

 

Thanks!

 

 

 

1 ACCEPTED SOLUTION
Cmuglioni
Frequent Visitor

Update: I found the problem to my issue. In Excel I have a specific slicer for year and it wasn't working with the only table where I have values from previous year. I change the slicer for a simple year filter in this specific table and it works just fine!

View solution in original post

1 REPLY 1
Cmuglioni
Frequent Visitor

Update: I found the problem to my issue. In Excel I have a specific slicer for year and it wasn't working with the only table where I have values from previous year. I change the slicer for a simple year filter in this specific table and it works just fine!

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.