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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi rodrigor,

 

As the report get data from SQL Server database, it requires gateway after publish to service.  Have you created a SQL Server data source under data gateway and configure the dataset to use that data gateway? For more information, see: Manage your data source - SQL Server.

 

Best Regards,
Qiuyun Yu

rodrigor's avatar
rodrigor
New Member
9 years ago

thanks Qiuyun Yu. Is it actually necesary to do this. Other reports and controls are working fine without the gateway. It is just the text field that is causing the report to break. More details in my reply to Guavaq.