Get hyperlink (image url) from sharepoint and visual as picture in power BI

[KhairulIzwar]

Hi, 

In my sharepoint, the multiline (hyperlink) show as below, but in power BI it turn as below. My objective is to show picture in power BI

Sharepoint - https://cdn.kascore-sea.osi.office.net/att/64b1db8da439c0c77d0ca82ef7b169e6a60bc4ae5103db5eafb49cb66...
​

Power BI - <div class="ExternalClass67C0E21A1DAE47F6AE8E67330D9510DA">https&#58;//cdn.kascore-sea.osi.office.net/att/64b1db8da439c0c77d0ca82ef7b169e6a60bc4ae5103db5eafb49cb664e9523b.jpg?sv=2015-12-11&amp;sr=b&amp;sig=ne%2FMYqmKyjaVIp5tU%2FI5dhERh7GQ%2BxsqGa6v0b7Qs8o%3D&amp;st=2020-07-22T00&#58;33&#58;10Z&amp;se=2294-05-07T01&#58;33&#58;10Z&amp;sp=r&amp;rscd=attachment%3Bfilename*%3DUTF-8''IMG_20-07-22_093301188_1.jpg&amp;mdId=EABhR3duiMwyOz05sDY/vhhJEjM+8X9GFyuWZMx/Xn/Kn1JVRSAC/s+3NzU/DMkfmdWEF74Lvj6ICrr919xDx1TC2akNszffd7CYINJFVabkMlKBKC099P2ohWc86vtqiIybrCwiTwFSunYwGAgERiwDSM8c0vUTQKUsrOVW51y2spW2crhoACLAV2G7fOJ3X6VsdmL9q9mK0RPlc94nYSdyVpLEicZY5oWfafy5eio6r14VKJStuPM+21TOIVAmcJw8pVDlaphtqhmDwTIeJFSsb6gECzD87oiTpSEH5ijyuerpj4MTFdEcWkOftiTDgGsI0CDHKMEt+nlUjiqLvaJjoguhl1R42wSKm1vgi93/hiUScERFWOz5qN5kEr7G+JM=​<br>​<br></div>
​

How to get back the same format in sharepoint or can I show picture by using power BI format ?

thanks guys 

[mwegener · Accepted solution]

Hi @KhairulIzwar ,

look at this.

[mwegener]

Hi @KhairulIzwar ,

How does the link get from SharePoint to PowerBI?

You could use the Column from Examples feature in Power Query to extract the URL.

[KhairulIzwar]

Hi @mwegener ,

I automate user answer (data type - picture) in Kaizala into sharepoint list.

string(triggerOutputs()?['body/answer1'])

I need to string this answer as its content more than 299 car

Thank you for 

[mwegener]

Hi @KhairulIzwar ,

I can't quite follow you.

What problem do you want to solve?
Does the transfer from "Kaizala" to "SharePoint" with PowerAutomate not work properly

or should the data be prepared with Power Query for display in Power BI?

[KhairulIzwar]

Hi @mwegener 

Data should be prepared with Power Query for display in Power BI. 

Data transfer from Kaizala to Sharepoint works well.

Actually, i try  use the Column from Examples feature in Power Query to extract the URL, but all goes to same as example i put 😞 

In Sharepoint

in Power Query

Thanks

[mwegener · Accepted solution]

Hi @KhairulIzwar ,

look at this.

[KhairulIzwar · Accepted solution]

Thank you so much @mwegener !. Very appreciated your help. 

My problem resolved !