Error refreshing: The command has been canceled.

Hi Angelia,

Thank you very much for your reply.

This would have been the next step for me, however, after much debugging and frustration, i found the reason.

To resolve the problem, i created a copy of my workbook and then started removing data sources one at a time.

Finally, after removing some of the tables, the error message became more meaningful: "The specified culture is not supported.. The exception was raised by the IDataReader interface."

I reopened my copy of the original workbook. I had set the culture to English (Denmark). After changing this to English (UK) and refreshing data sources + republishing everything works fine.

I don't know why the original error message masked the real error before. I did nothing in the original workbook other than changing the culture. So it must have been the same error, just not surfacing correctly.

I hope this helps someone else with the same problem.

Best regards,

Martin