Forum Discussion

rgouette's avatar
rgouette
Helper II
1 year ago
Solved

How to present this data(URL's & text) from SQL into a visual?

I have a SQL column that could contain any #of web links, and text.

I am trying to display this in a single Powerbi field, but with no looping capability, no recognizing HTML tags, and with the "Web URL" Data Category turning everything in the field into one URL, I'm failing...

 

I'd like the PowerBi result to look like:

 

An example of the SQL:

<p><a href="https://hislaboratory.sharepoint.com/:w:/r/sites/JMCRSIT/_layouts/15/Doc.aspx?sourcedoc=%7BF51AC40D-18FF-4EB1-A4F5-9AD2D0ECC066%7D&amp;amp=&amp;file=TrainOps%20KB%20article.docx&amp;action=default&amp;mobileredirect=true" title="https://hislaboratory.sharepoint.com/:w:/r/sites/JMCRSIT/_layouts/15/Doc.aspx?sourcedoc=%7BF51AC40D-18FF-4EB1-A4F5-9AD2D0ECC066%7D&amp;amp=&amp;file=TrainOps%20KB%20article.docx&amp;action=default&amp;mobileredirect=true" target="_blank">VideoLink</a></p><p>The tumor shows glandular formation consistent with moderately differentiated adenocarcinoma. Immunohistochemical staining for mismatch repair proteins is intact, suggesting microsatellite stability. </p><p>Recommend correlation with clinical and radiologic findings and consideration for surgical resection.</p><p><a href="https://www.google.com/" title="https://www.google.com/" target="_blank">Google</a></p><p>Some more fancy text…</p><p></p><p></p><p></p>

 

Any help/advice is appreciated..

~Rich

Need Help

8 Replies

    • rgouette's avatar
      rgouette
      Helper II
      1 year ago

      How did you get the crlf in there? mine is one block..

      • MFelix's avatar
        MFelix
        Super User
        1 year ago

        Hi rgouette 

         

        I copied the syntaax you sent on the post and just used it directly.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi rgouette ,

    Thank you for providing the details. Since you want to display multiple clickable links and formatted text from a single SQL column, it’s important to note that Power BI’s standard visuals cannot render HTML content. If you set the Web URL data category, the entire field will become one hyperlink, which may not suit your needs.

     

    As MFelix , mentioned, using a custom visual such as the HTML Viewer from AppSource is a good solution. This visual can read HTML tags directly from your SQL data and display them correctly in your report.

     

    After importing the visual, bind your column to it, and it should display your content with the intended links and formatting.

     

    Thanks for your response MFelix .

     

    Regards,
    Yugandhar.

  • rgouette's avatar
    rgouette
    Helper II
    1 year ago

    trying to decipher. for my application.. much appreciate the new angle on this!