Can't update semantic model on web, only on Desktop

[Dobson]

I need help, when I try to set up an automatic update, I get this 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: https://go.microsoft.com/fwlink/?LinkID=285987.. Microsoft.Data.Mashup.ErrorCode = 10478. . The exception was raised by the IDbCommand interface.

Manual updates and Publish works on Desktop version, but I need to have this updated daily.

I can't install any programs or drivers because i'm on a work pc.

[Tahreem24]

@Dobson Did you try publishing it in new workspace and then apply online refresh?

[Dobson]

Hello Tahreem,

Thank you for your answer, I tried what you proposed, but it shows the same error.

[v-hjannapu]

Hi @Dobson,

Thank you  for reaching out to the Microsoft fabric community forum.
 Since your file is already in SharePoint Online but still showing the same error, it looks like Power BI is not connecting through the right SharePoint path.

Please check once in Power BI Desktop  open Data Source Settings and make sure the path starts with https:// not something like a local or mapped drive path.

If it already shows the correct SharePoint link, try reconnecting the file.

If it still fails, please share a screenshot of the refresh error message and the data source credentials section hide any personal details. That will help us check what’s going wrong.

Regards,
Community Support team.

[v-hjannapu]

Hi @Dobson,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

[v-hjannapu]

Hi @Dobson,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.

[Shahid12523]

You’re getting that error because Power BI Service can’t refresh Excel files stored locally. To fix it without installing anything:
Move the Excel file to OneDrive or SharePoint Online
Reconnect in Power BI using the cloud URL
Publish again — now auto-refresh will work

[Dobson]

Thanks for your quick reply Shahed,

The Excel file is on a SharePoint Online, but still fails, I don't know why, I'll paste the Query if it can help:

let
Source = SharePoint.Files(
"https://aquachile.sharepoint.com/sites/PersonasPlantaCardonal",
[ApiVersion = 15]
),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Name], "CONSUMOS") and Text.Contains([Name], "1936")),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each ([Extension] = ".xls") and ([Name] <> "CONSUMOS1936 1757851200250_769640727.xls" and [Name] <> "CONSUMOS1936 1757937600538_553198584.xls")),
#"Filtered Hidden Files1" = Table.SelectRows(#"Filtered Rows1", each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (3)", each #"Transform File (3)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (3)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (3)", Table.ColumnNames(#"Transform File (3)"(#"Sample File (3)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}}),
#"Removed Top Rows" = Table.Skip(#"Changed Type",4),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"CONSUMOS1936 02Febrero 2025.xls", type text}, {"PERFIL", type text}, {"ENTIDAD", type text}, {"AREA", type text}, {"CCOSTO", type text}, {"CARGO", type text}, {"RUT", type text}, {"NOMBRE", type text}, {"FECHA", type date}, {"Almuerzo", Int64.Type}, {"Colacion Fria", Int64.Type}, {"Cena", Int64.Type}, {"Cena Noche", Int64.Type}, {"Colacion Mejorada", Int64.Type}, {"Once", Int64.Type}, {"Desayuno", Int64.Type}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type1", {"CONSUMOS1936 02Febrero 2025.xls", "PERFIL", "ENTIDAD", "AREA", "CCOSTO", "CARGO", "RUT", "NOMBRE", "FECHA"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Columns",{{"CONSUMOS1936 02Febrero 2025.xls", "Excel de Origen"}}),
#"Added Conditional Column" = Table.AddColumn(#"Renamed Columns", "Custom", each if [Value] = 1 then "Consumo" else null),
#"Added Custom" = Table.AddColumn(#"Added Conditional Column", "Origen", each "Corporativo"),
#"Renamed Columns2" = Table.RenameColumns(#"Added Custom",{{"Custom", "TipoConsumo"}})
in
#"Renamed Columns2"