Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Hyperlink to Sharepoint Online List in a table coloumn- no https

Hey guys,

 

I would like to create hyperlink to a Sharepoint Online List Folder. The problem I'm facing is that for some reason I do not get the complete URL, the beginning "https:" part is missing, it only starts from the /sites/xysharepoint...

 

I still changed in Modeling the Data Category to "Web URL", but as I do not have the https: part, Power BI does not consider it as a Web URL.

 

My question would be, if you know by any chance how it is possible to create a hyperlink without https: or if you have an idea why I do not see the whole URL path? In the beginning at "Get Data" I had to put in the whole URL, otherwise the connection would not have been established.

 

Many thanks,

 

Adam

 

Expan_Field_Values_as_Text.JPGWebURL.JPGWebURL_2.JPG 

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

To reproduce this problem on my site, please provide some details

do you connect with "SharePoint List", or "SharePoint Online List",or 'SharePoint Folder"?

Which URL do you paste when Get Date?

 

Does the url without "https:" exsit in the original dataset from the data source? it refers to a SharePoint List or a SharePoint Folder?

 

Based on my knowledge, to create hyperlink to a Sharepoint Online List Folder, you could refer to the following links

https://docs.microsoft.com/en-us/power-bi/power-bi-hyperlinks-in-tables

https://community.powerbi.com/t5/Desktop/Retrieve-attachment-from-SharePoint-online-list/td-p/334449

 

Best regards

Maggie

View solution in original post

2 REPLIES 2
Neeesz78
Regular Visitor

@v-juanli-msft   is it possible to add a column in PowerBI (URL) to open List items directly using ID ?

 

v-juanli-msft
Community Support
Community Support

Hi @Anonymous

To reproduce this problem on my site, please provide some details

do you connect with "SharePoint List", or "SharePoint Online List",or 'SharePoint Folder"?

Which URL do you paste when Get Date?

 

Does the url without "https:" exsit in the original dataset from the data source? it refers to a SharePoint List or a SharePoint Folder?

 

Based on my knowledge, to create hyperlink to a Sharepoint Online List Folder, you could refer to the following links

https://docs.microsoft.com/en-us/power-bi/power-bi-hyperlinks-in-tables

https://community.powerbi.com/t5/Desktop/Retrieve-attachment-from-SharePoint-online-list/td-p/334449

 

Best regards

Maggie

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.