cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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.

3 REPLIES 3
Highlighted
Super User III
Super User III

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

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)

Highlighted
Frequent Visitor

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

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

Highlighted
Super User III
Super User III

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

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.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors