We've had issues with refreshing report data with our powerbi embedded server for a while now. When creating the report, refreshing works just fine with own machine, but when uploaded to the server, refresh fails. It sometimes seems to work and sometimes doesn't. Error messages look like this:
Last refresh failed: Mon Apr 09 2018 00:02:55 GMT+0300 (FLE Daylight Time) There was an error when processing the data in the dataset.Hide details
Data source error:
The command has been canceled.. The exception was raised by the IDbCommand interface. Table: Metadata.
SQL server is the same but table where it fails seems to be random. Today even the reports stopped showing. We need to get this fixed asap, because reports go to our customers.