Refresh error: OLE DB or ODBC error:Exception from HRESULT: 0x80040E4E ,The command has been cancel

[Anonymous]

Hi,

I am getting refresh error on powerbi service Saying 

The command has been canceled. Table: xyz

When i try to refresh it on power bi desktop it Shows me the below error:

I tried to refresh the table showing error individually it worked and i tried to refresh on demand the data on power bi service which worked as well.

But this error keeps poping up nce in a while plus i am unable to refresh the data on power bi destop for all the tables together.

My Data source is SQL queries and my file size is 100MB

Please suggest what can be done to fix this problem.

Thanks in advance!

[nancyvangrrr]

Hi, I haven't seen this solution mentioned so I thought I'd share. I made some changes to column types in Power Query, but since they didn't match what was assigned in Desktop, I kept getting this error message. After changing the column types to match what was in Desktop, the issue was resolved!

For example, I had a column DimAccountID set as whole number in Power Query (transferred over from a SQL database), but it was actually saved as a text column in Desktop. After changing the format from whole number to text, I didn't receive the error message anymore.

[v-lionel-msft]

Hi @Anonymous ,

Try to change the data type of the columns:

Please refer to the video and the case, which can help you:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D | Power bi Refresh Error 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".