Refresh failure in the Service. No problems in Desktop...

Hello everyone,

Recently one of my report refresh jobs started to fail in Power BI Service. Error message below:

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

• MessageMicrosoft SQL: Invalid column name 't0_0'. ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Table: EDITracking_NoResponseDetail.
• Cluster URIWABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
• Activity ID4585ac80-df28-4c77-8119-4eeb1c6c5dab
• Request ID00ef4d5f-3dce-c7c8-22bf-1de85f1fb099
• Time2019-12-18 13:53:17Z

The name of the table that it throws the error on seems to be mostly random as it changes when I run the job again. There is no column in the entire database with that name, and nothing with that name was added inside of the .pbix

I opened the .pbix and tested the refresh, where it works fine. I can republish with no errors, but as soon as I refresh in the service, it fails again. I searched around and found others with a similar issue that was related to dates, so I double checked that all dates are in a valid format.

From what I can tell, the error is referencing a SQL query that I don't have access to view/edit. Does anyone have additional ideas on how to troubleshoot this?

Thank you!