Certificate added caused only Import Reports to fail.

[elliotdixon]

Hi All,

I am using an on premise enterprise gateway and we have added a internal certificate that has stopped the import reports for refreshing. Direct Query reports are working fine.

the certificate has been setup with the full path of the database  = DATABASE.DOMAIN.Local

I have changed the gateway to match this.

However on my  personal computer I cannot connct to the databases using this name.

Any ideas would be good.

[elliotdixon · Accepted solution]

Sorted - I read through this.

https://community.powerbi.com/t5/Issues/SQL-connect-error/idc-p/220934

on a hunch just ran power bi on my computer as an admin and it worked fine.