The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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)
We are referencing the sharedrive via \\global.*company*.com\sharename on all of our datasources
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.