Couldn't load the data for this visual

[kdkimble]

When I run this report on Power BI Desktop - it works and displays just fine.  The error is being triggered on the details (Table).  Latest update?  What is causing this?  I am getting this for a lot of reports now.  When I check the refresh history, there are no errors.  I need some help as this is rendering alot of my reports as useless now.  The filters, charts all display data.  When I look at the design there are not any errors displayed in PBI Desktop.  Please advise.  Source data from direct query to SQL database.  Nothing fancy or complicated here.  Records a few thousand (under 10,000) rows.

[v-haibl-msft]

@kdkimble

Please make sure you are using the latest version of gateway. And SQL Server does not allow some operations on text/ntext/image data types. It’s a known limitation in SQL Server. You can check the SQL DB and fix the data type.

If issue persists, please try to collect the fiddler traces with following option checked and share to us.

Best Regards,
Herbert