Power BI Server fails to refresh, yet refresh's on Desktop

[LParker97]

Hi, Me and my colleague have recently added a file to the PowerBI Server, It succesfully refreshes on PowerBI Desktop but the scheduled refresh has the following error:

[0] -1055784932: Unspecified error. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface

We think it's to do with the connection to the data sources which are on a shared drive, but we are unsure how. If anyone is able to give us a fix, that would be fantastic. Thankyou.

[d_gosbell]

How are you referencing the shared drive? Are you using a drive letter (eg g:\ ) or are you using a UNC path (eg \\servername\sharename)?

Because drive letters are mapped per user and the service account for PBIRS probably does not have any drives mapped so if you want to do a scheduled refresh from a shared drive you need to use a UNC path (which you need to set in your original pbix file)

[LParker97]

We are referencing the sharedrive via \\global.*company*.com\sharename on all of our datasources

[d_gosbell]

Sorry, that's the most common issue I see when trying to refresh from shared drives. Unfortunately the "unspecified error" does not give us anything to go on. You may need to look at raising a support case with Microsoft.