Converting project links from report to hyperlink in Power BI

edited 08/05/21 in Using Smartsheet
08/05/21 Edited 08/05/21
Accepted

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

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @Kim Harrison

    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

Answers

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @Kim Harrison

    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

  • Thanks, @Genevieve P.! I will ask over in the Power BI community.

Sign In or Register to comment.