Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Anonymous,
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
Hi @Anonymous,
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
In SSAS tabular data view.
Select the column,
Goto Properties
Reporting Properties
Data category
select webUrl.
Hi @Anonymous,
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
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.
Hi @Anonymous,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |