HTML Viewer dropping off SharePoint part of URL and Erroring

[Annaleesa]

My Power BI Report has several HTML viewers on the page pulling from different Notes columns in Lists. Most of the Notes columns include links to our OneNote stored in SharePoint. The links were opening fine when I had the report stored in my personal database. However, now that I've published the report to my team's SharePoint, the URL keeps erroring because it drops of the first part of the URL that includes the SharePoint address. I'm able to open other links fine, just any URLs from the same SharePoint are truncated to not include the Sharepoint part. Example screenshots below.

Pop-up when I try to open URL in old report:

Pop-up when I try to open the same URL in new report stored in SharePoint:

It's dropping off the redacted.SharePoint.com section and nothing else. Anyone know any workarounds besides storing in different sections? I need all these reports stored in the same team SharePoint. 

[Annaleesa]

I also tried linking a different OneNote under a different Sharepoint and it did the same thing. It seems like it has issue with the "redacted.sharepoint.com" part since it shares the same URL in the data source so even if I did store it elsewhere, I think it would cause the same error unless not in the same work domain. 

[christinepayton]

If the URL you're using is a column on the table, you can just add a custom column that concatenates the https://whatever.sharepoint.com with the other column to make a complete link? In Power Query you can just use an "&" to concat -  so "https://tenantname.sharepoint.com" & [other url column here]

[Annaleesa]

That wouldn't work for how I'm using the links as I have it saved with other notes among the hyperlink. This wasn't an issue before I moved the data source to the same sharepoint as the links I'm trying to include, so I'm unsure if there is a way to get the link to stop truncating besides moving the data soruce to another sharepoint

[christinepayton]

Oh, if it's in a notes field with other stuff, you should be able to do a "replace" step on the column - just replace "/sites/" with "https://yourtenant.sharepoint.com/sites/". This is assuming you don't have other hyperlinks with /sites/ in the path. 

[Annaleesa]

I did that, and it still errors. The issue seems to be when I go to open the link. The link will show fine in the html viewer and then it truncates when I select it. I've tried looking through settings, but I'm not sure why sharing part of the same URL as the data source is causing an issue 

[Anonymous]

Hi @Annaleesa 

This issue seems regarding the HTML Viewer in Power BI and the truncation of SharePoint URLs.

Ensure that the URLs in your Notes columns are correctly encoded. Special characters in URLs should be URL encoded. For example, spaces should be encoded as %20, and the /forward slash as %2F. This is crucial when URLs are parsed or processed by different systems.

Make sure that the URLs in your Notes columns are absolute URLs, including the part and the domain name(https://). Relative URLs might not resolve correctly when the report is accessed from a different base URL (e.g., when published to SharePoint).

Ensure that the integration settings between Power BI and SharePoint are correctly configured. This includes checking if there are any settings that might affect how URLs are handled or displayed within Power BI reports.

Or you might consider using a URL shortener service for your SharePoint URLs. This can help avoid issues with long URLs or special characters, although it adds an extra step in managing your links.

Here for your reference:

View Power BI files in OneDrive and SharePoint - Power BI | Microsoft Learn

Integrate Power BI reports in SharePoint Online | Microsoft Power BI Blog | Microsoft Power BI

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Annaleesa]

The links themselves are fine. They worked on the same report when the same data source was stored in my personal SharePoint, but now that I've moved it to the same SharePoint as the OneNote I'm trying to link to, now it's truncating. I'm trying to look in both settings for any integration issues between Power BI and SharePoint that would be causing the issue with the URLs and I'm not seeing anything in Power BI Options or SharePoint settings