Can't display visuals on service

[jhatton]

I have made a report in the desktop application, however, when I publish it the tables in the report get a Can't display the visual error

[v-qiuyu-msft]

Hi @jhatton,

Which kind of data source did you use in the report to get data? Did this data source requires any gateway? If it is, please configure gateway for the data source.

Best Regards,
Qiuyun Yu

[jhatton]

It connects to an Azure SQL database. All of the visuals pull from the same data source and only some tables are broken, its seems to only be tables that have values from multiple database tables. Also on the tab that it loads on the visual works but when I click refresh the visual breaks. 

[jhatton]

Update:

Seems to have something to do with text fields in the table visuals. If I remove every text field the visual starts working