Forum Discussion
Error refresh model semantic imposible excel in sharepoint
- 1 year ago
Creo que ya he encontrado la solución , pero repito algun cambio en el servicio ha habido, la pongo para el que pueda ayudar es cambiar la forma de combinar los archivos de la carpeta de sharepoint haciendo un combine files sin la función externa
let
Origen = SharePoint.Files("https://kuredusoftware-my.sharepoint.com/personal/cesar_kuredusoftware_com", [ApiVersion = 15]),
ArchivosFiltrados = Table.SelectRows(Origen, each ([Folder Path] = "https://kuredusoftware-my.sharepoint.com/personal/cesar_kuredusoftware_com/Documents/TELEMEDIDA/2024/")),
// Transformar cada archivo
Transformados = Table.AddColumn(ArchivosFiltrados, "Datos", each
let
Binario = [Content],
Excel = Excel.Workbook(Binario, null, true),
HojaCurva = Table.SelectRows(Excel, each [Name] = "Consumos diarios"){0}[Data]
in
HojaCurva
),
#"Se expandió Datos" = Table.ExpandTableColumn(Transformados, "Datos", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8"}, {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8"}),
#"Otras columnas quitadas" = Table.SelectColumns(#"Se expandió Datos",{"Name", "Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8"}),
#"Encabezados promovidos" = Table.PromoteHeaders(#"Otras columnas quitadas", [PromoteAllScalars=true]),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"CASER STA LEONOR_506_202505041937.xls", type text}, {"Fecha", type text}, {"P1", type text}, {"P2", type text}, {"P3", type text}, {"P4", type text}, {"P5", type text}, {"P6", type text}, {"TOTAL", type text}}),
#"Personalizada agregada" = Table.AddColumn(#"Tipo cambiado", "Fecha Nueva", each if Value.Is([Fecha], type number) then Date.From(Number.From([Fecha])) else [Fecha]),
#"Columnas quitadas" = Table.RemoveColumns(#"Personalizada agregada",{"Fecha"}),
#"Columnas con nombre cambiado" = Table.RenameColumns(#"Columnas quitadas",{{"Fecha Nueva", "Fecha"}}),
#"Tipo cambiado2" = Table.TransformColumnTypes(#"Columnas con nombre cambiado",{{"Fecha", type date}}),
#"Filas filtradas" = Table.SelectRows(#"Tipo cambiado2", each ([TOTAL] <> "TOTAL"))
in
#"Filas filtradas"
Hi risraspakas,
The error you're encountering in Power BI occurs because the required OLEDB provider, Microsoft.ACE.OLEDB.12.0, is not installed on your system. This provider is essential for Power BI to connect to certain Excel files, especially if you're using the 64-bit version of Power BI.
To resolve the issue, you need to install the 64-bit version of the Microsoft Access Database Engine 2010 Redistributable, which contains the necessary OLEDB driver. You can download it from the official Microsoft site. During installation, if you have a 32-bit version of Microsoft Office already installed, you might encounter a conflict. In that case, you should open the Command Prompt as Administrator and install the file using the command AccessDatabaseEngine_x64.exe /quiet to bypass the conflict silently. Once installed, restart Power BI and attempt to load your Excel file again. This should resolve the “provider not registered” error and allow Power BI to successfully connect to and import data from the Excel file.
Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!
Thank you.