Forum Discussion
Kudo CollectorLinks to Network Shares
I need to be able to access files that are stored on a network share. I'd like to be able to just click on the link and get the file.
I have 2 columns named Folder_Location(UNC path - \\Server\Folder\) and FileName.
I merged these 2 columns into FileLocation(\\Server\Folder\FileName). These steps work.
How can I turn the FileLocation column into a link the user can just click on to get the file??
8 Replies
GuyJohnsonForgot to mention - I want to do this in Power BI Desktop
- Eric_Zhang
Microsoft Employee
What do you mean get the file? To get the file content, I think you can create a custom column. The Accessing data function(Csv.Content in demo) depends on the file type in your case. Then you expand the table accordingly.
By the way, why do you have to use that way to get data, for me it is a little bit weird, frankly.
- GuyJohnson
I'm sorry I ever asked this question now. You obviously didn't read what I wrote as your solution doesn't address it.
Also I could care less if you think it is weird or not. I asked and if you can't address it keep quiet.
Consider this closed.
- Eric_Zhang
Well, I think I did misread your question, that was why I say it was weird. If I've given any offence, I didn't mean to.
If your question is to get a hyper link(clickable), I think it is still not support. Check Hyperlinks in tables. It requires a "http://" or "https://" prefix when predicating a field.
You can submit your idea at Power BI Ideas and vote it up.
I am in the same boat here. I hope there has been some progress on this (Links to Network Shares). I need to connect to files on a network drive. People that use the Poser BI report can see all of their individual assigned items in multiple excel files. By having the link, they can go specifically to the excel file that needs to be updated. Improves and simplifies user experience. Need the "file://" function to work with the "\\server\name\file.xlsm" to work together as a link within Power BI. Thanks
