Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerBi Table not recognising mailto as a URL

Hey    I've been trying to get a mailto link to work in a PowerBi table, ideally with the URL Icon. This is pulling through from a Sharepoint Excel, the mailto link is made in a CONCAT function. An...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anand24 ,

 

Thanks for your response! Unfortunately as I am on Mac I am working on PowerBi Webapp, not desktop. I do not have access to the data category option!

I have tried formatting the values to appear as URL, and I have tried the web icon. However, this does not work 😞

 

Matthew

Anand24's avatar
Anand24
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

I don't think changing datatype and setting it to URL is possible from Power BI Services. You will have to perform those in Power BI Desktop.

 

Also, pulling data from excel/sharepoint excel makes PowerBI pull data as text and not link. That's why even if you might have concatenated field as link in excel, it won't be recognised in Power BI.

 

Suggestion: Download your pbix file from services, make required data type URL changes from desktop and publish back to services.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!