Forum Discussion
Auto refresh failure IDbCommand interface failure on renew sharepoint.map connection
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 mess...
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.