The column '' of the table wasn't found.. The exception was raised by the IDbCommand interface

[sanjay009]

I am getting the error in power bi report server 'The column '' of the table wasn't found.. The exception was raised by the IDbCommand interface' for schedule refresh status.

I downloaded to power bi desktop, all my datasources Refresh is working fine with no errors. 

Please help how can i debug this issue.

SessionID: b65d21d6-92be-4293-999b-f51f21064990
[0] -1055784932: The column '' of the table wasn't found.. 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.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[KBO]

Hi @sanjay009 ,

I would go into the Power Query Editor and check every table! May be the refresh failed and you got no message (this is possible).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[FarhanAhmed]

In Power BI Report Server what credentials / connectionstring are you using in Datasource Tab ? Make sure that you didn't put 'local' in connection string.

What is your data source?