Converting project links from report to hyperlink in Power BI
I have a report that I am using to feed into a Power BI file. There's a column in the report for a link to individual project sheets, but this column shows up at text only in Power BI (For example, a clickable hyperlink to "Sheet A" in Smartsheet shows up as "Sheet A" as text only in Power BI). Is there a way to get the hyperlink into Power BI?
Best Answer
-
I found this discussion in the Power Bi Community, here, about formatting hyperlinks in Power Bi.
From this answer, it looks like Power Bi requires the Urls to be associated with http or https in order to be considered as Hyperlinks.
Even though the sheet hyperlinks in a Smartsheet Report have an underlying URL of https, this is not present in the cell of the Report. I believe this means it's not currently possible to turn these into Hyperlinks in Power Bi, but I would suggest posting in the Power Bi Community to confirm this behaviour.
Thanks!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
I found this discussion in the Power Bi Community, here, about formatting hyperlinks in Power Bi.
From this answer, it looks like Power Bi requires the Urls to be associated with http or https in order to be considered as Hyperlinks.
Even though the sheet hyperlinks in a Smartsheet Report have an underlying URL of https, this is not present in the cell of the Report. I believe this means it's not currently possible to turn these into Hyperlinks in Power Bi, but I would suggest posting in the Power Bi Community to confirm this behaviour.
Thanks!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
Thanks, @Genevieve P.! I will ask over in the Power BI community.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives