Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Converting SQL RTF values to Plain Text in a table visual

  • 1.  Converting SQL RTF values to Plain Text in a table visual

    Posted 9 days ago
    Hi
    I am reading data into Power BI from an SQL database.  I have a column of values coming in which are in SQL RTF code and I want to convert them  into plain text without formatting so I can read them in a table style visual. There seems to be solutions for converting HTML or Sharepoint RTF.  But none of these work for SQL RTF code which in my case always start {\rtf1\..........

    There must be lots of SQL users wishing to do this. As SQL is a Microsoft product I am surprised this isn't supported in Power BI itself.

    Does anyone know how this can be done?
    Thanks
    Rockingmark


    ------------------------------
    Rocking Mark
    ------------------------------