This is my first post in this community and I really hope you can assist me. I'm trying to create a report in Power BI, where I need some information about the SharePoint document location in Dynamics. I'm running into an issue once I load the Sharepoint Document information from Dynamics into Power BI. I'm able to fetch the SharePoint document location through Power BI, but when I try to get the absolute URL it is only obtainable through a function (see picture below). The dream scenario is that I'm able to get the URL itself directly into a table.
Do you have any suggestions on how to resolve this? Note that the data is gathered through the Dynamics API.