Forum Discussion

rodrigor's avatar
rodrigor
New Member
9 years ago
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...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

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.

rodrigor's avatar
rodrigor
New Member
9 years ago

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's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago
    When you click on See Details does it give you anything descriptive?
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.