Links to Network Shares

%3CLINGO-SUB%20id%3D%22lingo-sub-56233%22%20slang%3D%22en-US%22%3ELinks%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-56233%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20in%20Power%20BI%20Desktop%20and%20I%20need%20to%20be%20able%20to%20access%20files%20that%20are%20stored%20on%20a%20network%20share.%20I'd%20like%20to%20be%20able%20to%20just%20click%20on%20the%20link%20and%20get%20the%20file.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EI%20have%202%20columns%20named%20Folder_Location(UNC%20path%20-%20%5C%5CServer%5CFolder%5C)%26nbsp%3Band%20FileName.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EI%20merged%20these%202%20columns%20into%20FileLocation(%5C%5CServer%5CFolder%5CFileName).%20These%20steps%20work.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EHow%20can%20I%20turn%20the%20FileLocation%20column%20into%20a%20link%20the%20user%20can%20just%20click%20on%20to%20get%20the%20file%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20that%20a%20web%20URL%20can%20be%20accessed%20but%20how%20about%20a%20Network%20Share%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-56233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172749%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172749%22%20slang%3D%22en-US%22%3E%3CP%3E3...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57013%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57013%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20a%20forum%20of%202%26nbsp%3B%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57011%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57011%22%20slang%3D%22en-US%22%3E%3CP%3EOkay%2C%20i%20added%20my%20vote%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57009%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57009%22%20slang%3D%22en-US%22%3E%3CP%3EI%20voted%20for%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20one%20I%20created%20last%20Friday%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fideas.powerbi.com%2Fforums%2F265200-power-bi-ideas%2Fsuggestions%2F18713485-network-share-hyperlinks%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fideas.powerbi.com%2Fforums%2F265200-power-bi-ideas%2Fsuggestions%2F18713485-network-share-hyperlinks%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57008%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57008%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20only%20an%20year%20old%20idea%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fideas.powerbi.com%2Fforums%2F265200-power-bi-ideas%2Fsuggestions%2F13523046-data-category-for-local-file-file%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fideas.powerbi.com%2Fforums%2F265200-power-bi-ideas%2Fsuggestions%2F13523046-data-category-for-local-file-file%3C%2FA%3E%20which%20is%20voted%20by%20very%20few%20people.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57000%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57000%22%20slang%3D%22en-US%22%3E%3CP%3EThanx%20Sergei%20-%20That%20seems%20to%20be%20what%20I'm%20finding%20out%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20was%20also%20suggested%20in%20another%20place%20I%20try%20this%20-%20%26nbsp%3Bfile%3A%2F%2F%2F%2F%2Fmyserver%2Fpath%2Ffile.txt%26nbsp%3B%20This%20also%20didn't%20work%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20it's%20on%20a%20%22drawing%20board%22%20somewhere%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-56683%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-56683%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guy%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20my%20knowledge%20that%20doesn't%20work%20so%20far.%20Power%20BI%20Desktop%20(as%20well%20as%20G%26amp%3BT%20with%26nbsp%3BPower%20Pivot%2C%20same%20engine)%20converts%20the%20text%20into%20the%20hyperlink%26nbsp%3Bif%20only%20your%20text%20starts%20with%26nbsp%3B%22http%3A%2F%2F...%22%20and%20the%20column%20is%20categorized%20as%20Web%20URL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorkaround%20with%20text%20like%3C%2FP%3E%3CPRE%3E%22%26lt%3Ba%20href%3D%22%22file%3A%2F%2F%2F%5C%5Cmyserver%5Cpath%5Cfile.txt%22%22%20%26lt%3B%2Fa%26gt%3B%22%3C%2FPRE%3E%3CP%3Ealso%20doesn't%20work%20-%20no%20way%20to%20say%20to%20Power%20BI%20that's%20HTML%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-982923%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-982923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F237%22%20target%3D%22_blank%22%3E%40Guy%20Johnson%3C%2FA%3E%26nbsp%3B4%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2045166%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2045166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F237%22%20target%3D%22_blank%22%3E%40Guy%20Johnson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20fact%2C%20the%20functionality%20exist%20in%20PBI%20to%20open%20an%20external%20link%3B%20access%20a%20local%20network%20drive%20or%20open%20a%20file%20directly%20through%20a%20browser%20(not%20in%20PBI)%20but%20it's%20not%20known%20even%20to%20Microsoft%20Admins.%20Here%20is%20what%20you%20can%20do%20to%20access%20a%20network%20drive%20or%20a%20file.%3C%2FP%3E%3CP%3ETricks%3A%3CBR%20%2F%3E1.%20works%20with%20Edge%20or%20IE%20browsers%3CBR%20%2F%3E2%20use%20%22file%3A%2F%2F%22%20at%20the%20beginning%3CBR%20%2F%3E2.%20map%20using%20%22%2F%22%20instead%20of%20%22%5C%22%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.google.ca%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.google.ca%2F%3C%2FA%3E%3CBR%20%2F%3Efile%3A%2F%2Fabc-fb2%2Fhomedir%24%3CBR%20%2F%3Efile%3A%2F%2Fabc-fb2%2Fhomedir%24%2FHafizT%2FBRD%20Template.xlsx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2045258%22%20slang%3D%22en-US%22%3ERe%3A%20Links%20to%20Network%20Shares%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2045258%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F496953%22%20target%3D%22_blank%22%3E%40isynergized%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20to%20generate%20links%20in%20Power%20BI%20Desktop%20or%20Power%20Pivot%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fcreate-reports%2Fpower-bi-hyperlinks-in-tables%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdd%20hyperlinks%20(URLs)%20to%20a%20table%20or%20matrix%20-%20Power%20BI%20%7C%20Microsoft%20Docs%3C%2FA%3E%2C%20but%20that%20doesn't%20work%20in%20Power%20BI%20service%20and%20%3CA%20target%3D%22_blank%22%3Efile%3A%2F%2F%3C%2FA%3E%26nbsp%3Blinks%20are%20not%20supported.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

I am working in Power BI Desktop and 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??

 

I see that a web URL can be accessed but how about a Network Share???

10 Replies

Hi Guy,

 

For my knowledge that doesn't work so far. Power BI Desktop (as well as G&T with Power Pivot, same engine) converts the text into the hyperlink if only your text starts with "http://..." and the column is categorized as Web URL.

 

Workaround with text like

"<a href=""file:///\\myserver\path\file.txt"" </a>"

also doesn't work - no way to say to Power BI that's HTML code.

 

Thanx Sergei - That seems to be what I'm finding out

 

It was also suggested in another place I try this -  file://///myserver/path/file.txt  This also didn't work

 

Maybe it's on a "drawing board" somewhere

I found only an year old idea https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13523046-data-category-for-local-... which is voted by very few people.

 

 

Okay, i added my vote

We are a forum of 2  :-)

3...

@Guy Johnson 

In fact, the functionality exist in PBI to open an external link; access a local network drive or open a file directly through a browser (not in PBI) but it's not known even to Microsoft Admins. Here is what you can do to access a network drive or a file.

Tricks:
1. works with Edge or IE browsers
2 use "file://" at the beginning
2. map using "/" instead of "\"

https://www.google.ca/
file://abc-fb2/homedir$
file://abc-fb2/homedir$/HafizT/BRD Template.xlsx

@isynergized 

How to generate links in Power BI Desktop or Power Pivot is here Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Docs, but that doesn't work in Power BI service and file:// links are not supported.