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

[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 ?