Converting project links from report to hyperlink in Power BI

Kim Harrison

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?

Genevieve P.

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

Genevieve P.

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

Kim Harrison

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