- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-31-2017 12:47 PM
I am using a live connection to a Cube database in Analysis Services where my table has a field that includes URLs. I want to display these links (probably in a table) in my report as live/clickable rather than a text string. However, I can't set this in Power BI via the model, given that it is a live connection. It doesn't appear that adding HTML tags is going to do the trick, and I can't find any DAX functions that will allow me to do this as a measure. What can I do, either in Desktop or in the Service?
Solved! Go to Solution.
Accepted Solutions
Re: make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-08-2017 03:59 AM
Hi @mgcharumilind,
I have tested the connection to SSAS cube. It seems this should define in the cube. This video could help, please have a try. https://www.youtube.com/watch?v=ywaTxQKchx8
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
All Replies
Re: make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-02-2017 02:22 AM
Hi @mgcharumilind,
You can try this.
In Power BI Desktop. Modeling -> Data Category (Web URL). Publish it to Service if you want to use it in the Power BI Service.
NOTE: The URLS must start with http:// , https:// or www.
Please reference: powerbi-service-hyperlinks-in-tables
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-02-2017 06:11 AM
Thanks Dale, but there isn't any Modeling tab in the Live Connection to our Cube in Analysis Services. I have read that article several times wishign that it had my solution, but it only details Direct Query and Imported data. Hence my conundrum.
Re: make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-08-2017 03:59 AM
Hi @mgcharumilind,
I have tested the connection to SSAS cube. It seems this should define in the cube. This video could help, please have a try. https://www.youtube.com/watch?v=ywaTxQKchx8
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-08-2017 06:38 AM
In SSAS tabular data view.
Select the column,
Goto Properties
Reporting Properties
Data category
select webUrl.
Re: make URL clickable in live connection?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-21-2017 02:44 AM
Hi @mgcharumilind,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a help to the others.
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.