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

[rgouette]

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

[V-yubandi-msft]

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]

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

[MFelix]

Hi @rgouette ,

Have you tried an HTML viewer visualization:

https://appsource.microsoft.com/en-us/marketplace/apps?search=html%20viewer&page=1&product=power-bi-...

This can help you on what you need.

[rgouette]

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

[MFelix]

Hi @rgouette 

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

[rgouette]

I just realised they're paid solutions, so that won't work in this instance, thanks much though.

[SamWiseOwl]

Hi @rgouette 

This might get you started:

[SamWiseOwl]

Did this not work @rgouette ?