Forum Discussion
Text Field Can't display the visual
Hi rodrigor,
A change was made recently to send better Direct Query to SQL Server data source (and may be other).
But these queries use a function that is not compatible with text/ntext/image data type.
TEXT, NTEXT data types are deprecated. TEXT is non-unicode which can cause all kinds of problems
Please try to change data type to VarChar(Max) or NVarChar(Max).
Best Regards,
Qiuyun Yu
Hi there, do you have any more details around the error?
Hi guavaq, I oversimplified the report to make the trouble shooting easier. I created one report with an ID (whole number) field and a Comments (Text) field, both from a Azure SQL DB table. The report can filter the Comments using the IDs if I use Power BI desktop. The report won't work using the Service.
From the Power BI service
Power BI service
From Power BI desktop
Power BI desktop
If I remove the Comment (text) field from the report, and just add other non-text field to it (sentiment-Numeric, feeling-Numeric), the report works with any problems. So there is something with wrong displaying text fields in the Power BI service. I actually created a new Calculate column to clean and reduce the number of characters in the Comments field, and still the report won't display the text in the power Bi Service.
Hi rodrigor
Is there a relationship between the data?
And in your second screenshot there is nothing selected in terms of filtering using the slicer.
No relationships in between the data. One single table.
The second screenshot (desktop) has nothing selected, but if I select any filter from ID it works. The first screenshot, as soon as I filter from ID, I got that error message.
- When you click on See Details does it give you anything descriptive?