Consolidate and Hyperlink to Files on SharePoint

Рет қаралды 7,383

Күн бұрын

How to add a hyperlinks to allow you to instantly jump to your source files when consolidating from SharePoint.
Can be used in Excel and Power BI
00:00 Introduction
01:04 Navigating through SharePoint
04:12 Data extraction and consolidation
07:01 Creating hyperlinks in Excel
08:01 Implementing hyperlinks in Power BI
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/

Пікірлер: 37

@alexrosen8762 10 ай бұрын

Your tutorials are always very informative and useful

@AccessAnalytic 10 ай бұрын

Thank you 😀

@FredericLEGUEN-Excel 10 ай бұрын

I love the tip at 3:25 to split your navigation steps. Very clever 👏

@AccessAnalytic 10 ай бұрын

Cheers Frédéric

@tinaflemons263 10 ай бұрын

Incredible, thank you for sharing.

@AccessAnalytic 10 ай бұрын

You’re welcome

@bradfry6396 10 ай бұрын

Awesome Wyn, I know just the use for this. 😋

@AccessAnalytic 10 ай бұрын

😀

@cyloncycler 5 ай бұрын

So good, thank you!

@AccessAnalytic 5 ай бұрын

You’re very welcome

@ezequielaguirre3 10 ай бұрын

Great stuff as always! You are able to add the "friendly name" too if you want. You would have to click into another column of your table vis and activate the web URL in the "cell elements" options. And then assign the hyperlink to it.

@AccessAnalytic 10 ай бұрын

Yeah nice - I should’ve shown that

@JoeySlims89 3 ай бұрын

THANK YOU!!!!!

@AccessAnalytic 3 ай бұрын

You’re welcome!

@paspuggie48 10 ай бұрын

Ironically I developed a PQ tool at work for a customer which was basically identical. Great minds 😊

@AccessAnalytic 10 ай бұрын

Good stuff!

@pondyanand 10 ай бұрын

Great video ! The split hack was useful.

@AccessAnalytic 10 ай бұрын

Cheers

@edwardcallender5649 10 ай бұрын

Thanks

@AccessAnalytic 10 ай бұрын

You’re welcome

@FRANKWHITE1996 10 ай бұрын

great video, thx 4 sharing ❤

@AccessAnalytic 10 ай бұрын

No worries 😀

@iankr 10 ай бұрын

Many thanks, Wyn.🙂

@AccessAnalytic 10 ай бұрын

You’re welcome Ian

@utubeAgape 10 ай бұрын

Excellent - this will be useful. Thank you!

@AccessAnalytic 10 ай бұрын

You’re welcome Irene

@shaibeezz 7 ай бұрын

Hi Thank you for sharing an excellent video. I have a minor issue: the link does not open the file (online) but is constantly downloading the file, any suggestion

@AccessAnalytic 7 ай бұрын

Go to File - Options - Advanced - Link Handling and untick the box. I think that should work

@shaibeezz 7 ай бұрын

@@AccessAnalytic, 👍thank you.

@joseagundis1 10 ай бұрын

I like it the part 2:36 from Binary to Contents, Why Wyn? Thanks for sharing!

@AccessAnalytic 10 ай бұрын

Hi, do you mean why not just expand the binary?

@einoconsult5563 10 ай бұрын

Wyn, thanks for sharing. The eternal question is : do you know a workaround to connect a SP folder without having a E3 or higher license ? Is there any way to connect a SP with a regular Business Strandard licence, it is such a basic feature when you are a part of a team, I am not sure why Microsoft requires us to have expensive license for it ?

@AccessAnalytic 10 ай бұрын

Yep just type the =SharePoint.Contents( formula into a blank query and it will work. I don’t understand why they bother hiding the button

@Sumanth1601 10 ай бұрын

Excellent.. But the Split tip was very useful too.. Its really annoying to not see the folder path.

@AccessAnalytic 10 ай бұрын

Cheers, I like to drop in a few bonus tips in my videos, plus it will feed nicely into next weeks video

@danielchacko4009 10 ай бұрын

How would you do this if the sharepoint files are not all in the same sharepoint folder, but are rather in many different subfolders of a particular sharepoint folder?

@AccessAnalytic 10 ай бұрын

Check out Imke’s function here www.thebiccountant.com/2020/11/16/improve-file-import-from-sharepoint-in-power-bi-and-power-query/