refresh error failed runtime assertion

[Anonymous]

I'm getting intermittent refresh failures and I'm having trouble determining if it's the service or the source data which is SQL Server.  Here is the latest error message, can someone please confirm that this would likely be an error due to the source data as opposed to the service?

Thank you,

John

[GilbertQ · Accepted solution]

Hi @Anonymous

The error is with your data source, where it says that there is an error with the table "GymStatsGoal"

What I would suggest doing is opening up your Power BI Desktop file, finding the query and running that on your source system. I find that the easiest way to troubleshoot, because if it is a TSQL query, and you run it in SQL Server Management Studio, it will give you a more accurate error.