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
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.
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
These don't work for NVARCHAR either. Text boxes cannot be assigned a value unless Q&A is on. There is no apparent way to do this in Power BI Desktop.
A basic text visual is needed that can display a multi-line, left-aligned string (for example, a postal address). This cannot be done in Power BI without workarounds. This is why I am looking at alternatives to Power BI.