Forum Discussion
Solved
Text Field Can't display the visual
I have a report with Text records (user comments) that are filtered by another control in the same report. The Text records filter in Power BI desktop, but not when using Power BI service. I am using...
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
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.
GilbertQ
Super User
Super UserWhen you click on See Details does it give you anything descriptive?