search

dm-p / powerbi-visuals-html-content

Visualise column or measure values as HTML in your Power BI reports. Intended as a spiritual successor to the OG HTML Viewer custom visual, with some extra stuff thrown in.
MIT License
83 stars 19 forks source link

[BUG] links sources from same Sharepoint source data is stored are being truncated #110

Open Annaleesa opened 1 month ago

Annaleesa commented 1 month ago

Describe the bug The data I’m pulling is in Lists which is stored in my Company’s SharePoint. I’m using the html viewer to show links from one of the columns in Lists. Whenever the link is to something else stored in my company’s SharePoint, it truncates the link to drop off the “https://companyname.sharepoint.com”. I think it’s because that is the same link as the data source for the Power BI report. I’ve checked the Power BI settings along with my company’s security settings and neither should be interfering. Is it possible the truncating issue is sourced from the html viewer itself?

To Reproduce I’ll select the link in the html viewer and it will state “Cannot Open in Web Browser. The link is malformed” and will show the truncated link.

Expected behavior The link to open without truncating. It did this when I had the Power BI report in my personal Workspace, but stopped working once I moved the report to the company SharePoint where the links are also sourced.

Screenshots/Workbook Pop-up when I try to open URL in old report: image

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

Unsure if the visuals actually took, if not, here’s the link to where I posted about it in another forum including the same screenshots:

https://community.fabric.microsoft.com/t5/Desktop/HTML-Viewer-dropping-off-SharePoint-part-of-URL-and-Erroring/m-p/3880382#M1249137

Power BI Setup (please complete the following information):

*Visual Information (please complete the following information, available by right-clicking the visual in Power BI and selecting About*): HTML Content

Additional context Other links are able to open, it’s only when the link is sourced from the same SharePoint the Power Bi data is being sourced from

dm-p commented 1 month ago

Thanks very much for raising. This sounds like the column you're supplying to the visual for the hyperlink contains a relative URL? If so, this is not valid for what Microsoft allows in custom visuals: all hyperlinks have to be fully qualified with either the HTTP or HTTPS protocol.

For a relative URL, you must append a suitable protocol and server to the URL (ideally as far upstream as possible, e.g., Power Query) so that Power BI can resolve it on your behalf (we have to submit URLs to Power BI to delegate; custom visuals are not allowed to open hyperlinks themselves).

If the dataset contains a fully qualified URL that is being supplied to the visual correctly and then somehow truncated afterward, this shouldn't happen and is indeed a bug. In that case, I will need to see suitable data that reproduces the issue. If you can provide a sample .pbix or dataset, this will be a great help. Including the dataset in a separate table,visual is also useful, so it's easier to inspect the raw values in the context of the data model. If these are correctly prefixed with http(s):// in the visual table, then they should be represented similarly in HTML Content.

Annaleesa commented 1 month ago

I have the data stored in SharePoint Lists, but I have it exported to excel with an example for you to view. I also took a screenshot of the Power BI report attempting to open the same link as shown in the example in column G titled Notes1. The Lists data the Power BI report is sourcing from is also stored in the same place "https://tmobileusa.sharepoint.com/sites/" and is what keeps getting truncated from these links I'm attempting to have opened.

Annaleesa commented 1 month ago

I'm having issues attaching the screenshot and excel file so I will email them to you separately.