Retrieve attachment from SharePoint online list

I'm not sure what you mean. If I use that link format, I can get to any attached picture in SharePoint in my browser. Not sure what you are trying to achieve or how you are trying to access it. If you have the SharePoint as a trusted site, you can use URL's in that format to add images to your Power BI Desktop report. Can you explain your use case?

I tried few ways to do that. Best way is to have a llink and it works as you told. Thank you Greg_Deckler

I know this is marked as solved, but was one of the first hits on google and did not fit my use case.

I wanted to add a link to an excel file that was attached to a sharepoint list item.

1. Open the Query Editor and find the column named AttachmentFiles

2.Expand the table with the double arrow and select ServerRelativeURL. This will give you a new column called AttachmentFiles.ServerRelativeURL

3. Add a custom column to concat your Sharepoint URL and the Path  like this ="https://mysite.sharepoint.com" & [AttachmentFiles.ServerRelativeUrl]

4. Save and close the Query Editor

5. In the data table view, select the custom column you created and in the modeling tab select Data Category:Web URL

6. Add the custom column to your table visual and in formatting/values select URL Icon true to keep tidy.