Auto Refresh Error

[spandy34]

I have a Dashboard that has been refreshing automatically but noticed it hadnt been refreshed recently.  When I looked I saw the following error message

SessionID: 6ea840b1-5045-45ee-a9e4-1e03cbc260a4

[0] -1055784932: DataFormat.Error: Unspecified error. LACHS_Mirror251121.accdb. ;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.

My Dashboard is linked to a MS Access Database that is linked to our Insurance System via ODBC link.

The MS Access Database is called ACHS_Mirror251121.accdb

Does anyone know what this error means ?  Is the a problem with PBI or the MSAccess Database?

[v-luwang-msft · Accepted solution]

Hi @spandy34 ，

Click on the "..." menu when you hover over the report in Power BI Report Server. Choose the "Manage" option and then go into the "Data Sources" tab. If you want to schedule a refresh you will need to enter credentials against your data sources so that the scheduled refresh can authenticate against those data sources. 

Similar question refer:

https://community.powerbi.com/t5/Report-Server/Power-BI-On-Prem-scheduled-task-error/m-p/630164 

And similar question on report server :

https://techcommunity.microsoft.com/t5/sql-server-support-blog/scheduled-refresh-issue-with-pbix-rep... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[lbendlin]

It's a problem with the database. Check that it is not corrupted and that the lock file is not present.