Auto refresh failure IDbCommand interface failure on renew sharepoint.map connection

[Anonymous]

Question: Why is renew of the query working with the desktop version and not in the powerBI services.
In service the connection works and is ok we tested it with a singele excel.

Renew failure message

[ValidateMarkupTags][ccon]DataSource.NotFound: Excel Workbook: [ccon]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.[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: Vodafone Info.

parameters both:  Url_BI_Documents and Folder Path    are https URL 

table query: Vodafone Info

let
   source = SharePoint.Files( Url_BI_Documents, [ApiVersion = 15]),
   folderSelection = Table.SelectRows(source, each ([Folder Path] = CallData_Selectie)),
   removeHiddenFiles = Table.SelectRows(folderSelection, each [Attributes]?[Hidden]? <> true),
   functieBestandenOphalen = Table.AddColumn(removeHiddenFiles, "list tables", each #"unfold"([Content])),
   columnPrepare = Table.RenameColumns(functieBestandenOphalen, {"Name", "Call rapport name"}),
   columnSelect = Table.SelectColumns(columnPrepare, {"Call rapport name", "list tables"}),
   removeUnkownFiles = Table.RemoveRowsWithErrors(columnselect, {"list tables"}),
   unfoldFiles = Table.ExpandTableColumn(removeUnkownFiles, "list tables", Table.ColumnNames(#"unfold"(example)) )
in
  unfoldFiles

Function :  (Parameter1 as binary) as any

let
   bron = Excel.Workbook(Parameter1, null, true),
    callCenterCallDetailReport_1 = bron{[]}[Data],
    typeGewijzigd = Table.TransformColumnTypes(callCenterCallDetailReport_1,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text} }),
   verwijderHeader= Table.Skip(typeGewijzigd,10),
   headerTransformed = Table.PromoteHeaders(verwijderHeader, [PromoteAllScalars=true]),
   typeGewijzigd2 = Table.TransformColumnTypes(headerTransformed,{{"Call Center Name", type text}, {"Call Start Time", type datetime}, {"Call Answer Time", type datetime} })
in
   typeGewijzigd2

Renew from Desktops works fine and fast

[Anonymous]

@Anonymous @RossEdwards 
After doing different test, we see the problem is not in the connection.
But in the function,  it works fine on the desktop but after publishing it gives the connection error

Auto refresh failure IDbCommand interface failure on renew sharepoint.map connection.

[Anonymous]

Hi RossEdwards ,thanks for the quick reply.

Hi LiedjeV ,

If you have a Pro license you can open a Pro ticket at

Power Platform admin center (microsoft.com)

[RossEdwards]

Generally this means that you haven't installed the same drivers / configuration on your server that runs the on-premises data gateway.

I would suggest that you have installed something on your local machine to make this work, like Microsoft Access 64Bit, and this has installed a driver or package that makes this work.  There could also be some configuration associated with these drivers to makes things work too, so you'll need to see if you've done any additional set up on your machine.

Basically, think about all the things you'd install on a new work machine if you wanted to get it to work. Do that on the server.