URL where FileType = URL

[Peter52912]

I have a SharePoint document library that contains items where FileType = URL (i.e., they are plain URL items, not uploaded files or Office documents).

When I connect the library to Power BI, the File.Name column shows the display name of the URL, but I cannot find the actual URL anywhere.

Which field in the SharePoint document library stores the actual URL for these URL items, and is there a guaranteed way to retrieve it in Power BI without manually inspecting all nested record fields?

[v-venuppu · Accepted solution]

Hi @Peter52912 ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu]

Hi @Peter52912 ,

Thank you for reaching out to Microsoft Fabric Community.

For SharePoint library items where FileType = URL, File.Name shows only the display name. The actual URL is stored in a nested field, usually EncodedAbsUrl.

To retrieve it in Power BI:

Connect to the library using “SharePoint Folder”.Locate the column with nested records (often File or Attributes).Expand it and select EncodedAbsUrl.Rename it (for e.g., Actual URL) and use it in your visuals.

This gives the true URL for all URL items without manual inspection.

[Peter52912]

Many thanks. The key is to connect to SharePoint Folder

I'd been connecting to SharePoint list which pulls through so much metadata, for for some strange reason the url only comes through when you connect to the folder. Then filter to show just URLs and then expand the Binary column