Any way to get the URL to a file pulled from Sharepoint in Power Query?

[edhans]

I've pulled a series of files via the Sharepoint Folder connection. One of the things I'd like to do in my Power BI report is give the user a clickable URL so they could open a file that shows up on the report, but I cannot figure out how to get from the full file name to a URL. Just replacing the spaces with %20 gives me a download action, not an open in Excel/Excel action, and I definitely don't want them downloading it, because they will download it, make the necessary changes, save the file, and the only file that is correct is the now useless file in their download folder.

The Excel Online link looks like this:

https://tenant.sharepoint.com/:x:/r/sites/TeamName/_layouts/15/WopiFrame2.aspx?action=edit&sourcedoc={AAAAAAAA-FFFF-8888-AAAA-123456789012}

But I cannot find that GUID in the Power Query data to build the URL.

Suggestions?

[v-yuta-msft]

Hi edhans,

Based on your description, you want to create a hyperlink in power bi and let your user to click and choice if they want to download the file, right?

I'm afraid power bi doesn't have this feature. As a workaround, you can simply share the Sharepoint Folder to your users and copy the share link to table in power bi.

Regards,

Jimmy Tao

[edhans]

No. I want them to click on the file name and open the file in Excel Online. I can make it do the download. That is what I don't want, as that creates a copy - one in the source location, and another in their Downloads folder.

[v-yuta-msft]

Hi edhans ,

I'm afraid power bi doesn't have the feature currently, you can submit your idea here:

https://ideas.powerbi.com

Regards,

Jimmy Tao