@Access Analytic question, have you ever set up a "SharePoint" Server? Meaning you have a SharePoint dedicated to running queries that are aggregating from forms you created for your company on another SharePoint site. You can then query to this "SharePoint Server" site to get reports from?
To be honest this video has just paid for my year's RUclips subscription. Can you imagine what the world would be like if every video was this informative. I had practically given up on trying to get files out of Shitepoint until now.
Really, thanks for sharing your knowledge. You saved my day here. Was trying for 2 hours how to link it. The Power BI/EXCEL in app information is horrible for this. This video/tutorial deserves an OSCAR.
Man!! Lifesaver - I was using previous method - in our company we have a preservation hold folder that is bloated, so it was taking forever to load a file from one of the other folders because it has to first load all data from the other folders before I can filter for what I want
Wow. This is a neat workaround. Thanks for sharing this! I would generally avoid this method because the "drill down" isn't expanded and my worry is it isn't shown in Applied Steps. I guess by breaking them like what you showed here does the trick! So now whenever the folder path changes in future, I can go to that step and edit!
Hi Wynn. The SharePoint.Contents( ) approach works really well. For private channels in Teams, at first sight it looks as if SharePoint.Contents( ) does not return the private channel. That is because a private channel actually has a different SharePoint URL, so the first step Source will have to point to another URL.
Great video, put's light in a very complicated mechanism to access excel files. once again this proves how bad this non-feature was implemented from PowerBI point of view. The casual player will never figure out this. It has no explanation why power bi developers and sharepoint developers didn't manage to find a simple and easy way to access each specific folder !
Wow. This vidoe just transformed by process in a significant want, because my files are too large to have in a folder on my desktop. So i store my files in SharePoint and connect to folders to dynamically load the data
Thanks, you’d need to go into the advanced editor for that and combine the 2 steps into 1 and replace the path with a word like SourcePath, then create a parameter ( via parameter button ) called SourcePath
Very good video, helped me on import data from Excel and csv files hosted on Sharepoint folder. Appreciate it very much. However, this video is misleading to me as the formats of my Excel and csv files are different so do need to be consolidated. So I suggest you change the title to add "consolidate" in it as quite some contents in this video is about "consolid" your 3 excel files. Again, thank you for your video, expecially the tricks in it.
Thank you so much, this has been bothering me for such a long time. I don't understand why MS does not just allow you to connect to the subfolder directly instead of only allowing you to conect to the main Sharepoint site.
Glad to help out Donald. The breaking out of the navigation step was something I came across accidentally a few months ago. Really handy in when referencing dataflows too.
Consolidating multiple sheets from one file is here : ruclips.net/video/cPN24NK3_68/видео.html Consolidating multiple sheets from multiple files is tricky. Likely multiple “ from folder “ queries or the use of custom functions
Thanks for nice and simple way of explaining it. How can I dynamically pass SharePoint Link and Folder as a parameters so that we do not end-up rebuilding query every year or if same wants to use by multiple department but map with different SharePoint Site and Folder
Technically you can add a Parameters in Power Query (there's a button and wizard to create a parameter) then just replace the hard coded paths with the folder names. The difficulty with the SharePoint.Contents approach is there is an unknown number of folders to drill through so that will be a problem.
One of the spreadsheets had a table under the other. Now, in PBI I have two different data in one query. Can I remove half of the table into a new query, and would it keep its connection?
Thanks for this it will save me so much time! If the resulting file is to be shared by a group of people (within the same organization) do they all have to do the 'sign in' step? It seems unnecessary and inconvenient since they can already access the documents in sharepoint. Is there no way around it?
Thanks a lot for all your videos, incredibly clear and helpfull ! I was wondering, if I need to import only one or two files on a sharepoint, should I use preferably this connection to the sharepoint folder method or the simple web connection to the file directly? which one is the more efficient? thanks:)
This video is a genuine service to humanity
😂 - made me smile - thanks!
I agree 1000%. This video is gold and is something I never want to lose.
Thank you 😀
@Access Analytic question, have you ever set up a "SharePoint" Server? Meaning you have a SharePoint dedicated to running queries that are aggregating from forms you created for your company on another SharePoint site. You can then query to this "SharePoint Server" site to get reports from?
I am just speechless. What an unbelivably timesaving workaround.
To be honest this video has just paid for my year's RUclips subscription. Can you imagine what the world would be like if every video was this informative. I had practically given up on trying to get files out of Shitepoint until now.
Very kind, I appreciate you taking the time to let me know you found it useful
Even in 2024 this Video still makes me say : you are the Master !!!
Cheers Juan!
You are the only person who came with a decent solution that really works. Thanks!
You're welcome
Genius, Genius, Genius. I almost abandoned my project because of this frustration. Thank you
You’re very welcome. Thanks for letting me know
Holy c... - the speed on this solution is Amazing !!!! Instead of 5 minutes - I'm getting data in 30 seconds - Thank you very much !!!!!
You’re very welcome and thanks for confirming the speed gains
Finally! It was so hard to find such elegant solution to the problem of slow working with SPO folders...
I’m glad you found it useful.
Love the column size and contents hack! I've been scrolling all along. So glad I stopped down on this. Thanks so much.
You’re welcome. I appreciate you taking the time to let me know you found it useful
Really, thanks for sharing your knowledge. You saved my day here. Was trying for 2 hours how to link it. The Power BI/EXCEL in app information is horrible for this. This video/tutorial deserves an OSCAR.
😀 thanks Matheus
I was moved to No Code / Low Code world . Thank you so much for video.
You're welcome
Absolutely legend! Humanity rely on you. Lot of top you tubers got wrong here. You saving us. Bless you my friend. 🙏
Thank you
What an awesome hack! I can't believe Microsoft hasn't already baked the SharePoint.Contents functionality into their PQ menus. Thank you!!!
You’re welcome. I appreciate you taking the time to let me know you found it useful
Absolutely brilliant! Thank you so much. Finding subfolders in SP has been a killer for me until now. Much appreciated.
You’re welcome. I appreciate you taking the time to let me know you found it useful
MY GOD!!! Amazing! spent ages getting errors using other methods, love the simple exceptionally clear step by step presentation - Thank you!
You’re welcome Neil. Glad it helped and thanks for taking the time to leave a kind comment
How can I like this video many more times? Thank you for it!
😆Thank you!
Omg, finally found this! Agree, this is a genuine service to humanity
Hah 😆, thank you
"Move to beginning" - Such a time saver
Thanks 😀 All these little things help
You have saved my life! I wish I could give you a million likes. Thanks a lot for your clear and detailed explanation. Well done!
Glad to help Chinedum, thanks for taking the time to let me know it helped you. Hopefully you’ll let others know about this channel 😀
Thank you for posting a better/quicker way to connect to sharepoint folder! It worked very well for me!
You’re welcome
This video is excellent - the way you explain things is perfectly digestible, helped me alot!
You’re welcome. Thanks for taking the time to leave a kind comment
Agree with so many other comments! Thank you for sharing your knowledge in such a clear way! Many thanks!
You’re very welcome. Thanks for taking the time to leave a kind comment
Save my life. First time using sharepoint folder.
Excellent .. glad to help Felipe
I've been trying to solve performance issues for a week!! I'd LOVE this video if I could
Glad to help, thanks for taking the time to leave a kind comment
Man!! Lifesaver - I was using previous method - in our company we have a preservation hold folder that is bloated, so it was taking forever to load a file from one of the other folders because it has to first load all data from the other folders before I can filter for what I want
Excellent!
The solution is super elegant. Thank you so much !!!
You're welcome. Thanks for taking the time to comment.
Everything I was looking for and more, great video. Thanks!
Great! Thanks for letting me know
This is EXTREMELY helpful. Thanks very much for making this video.
No worries. Thanks for taking the time to leave a kind comment Sean
Thanks for solving puzzles for me. Love you man. You are great 👍
Too kind ☺️
Wow. This is a neat workaround. Thanks for sharing this! I would generally avoid this method because the "drill down" isn't expanded and my worry is it isn't shown in Applied Steps. I guess by breaking them like what you showed here does the trick! So now whenever the folder path changes in future, I can go to that step and edit!
Absolutely Alex, I used to feel the same way
Thank you! That was exactly what I was looking for! Finally I managed to connect with my subfolder on the Sharepoint.
Great! I appreciate you taking the time to let me know you found it useful
Thank you. I have used your teaching from this video today.
Thanks for taking the time to let me know it helped Julie
I wish I could give a x100 thumbs up. So useful for my job. Thanks
Awesome!
Thank you so much sir, this video help me a lot in my job. I didn't know what to do with SharePoint folder when my boos asked.
You are welcome. I appreciate you taking the time to let me know you found it useful
Hi Wynn. The SharePoint.Contents( ) approach works really well. For private channels in Teams, at first sight it looks as if SharePoint.Contents( ) does not return the private channel. That is because a private channel actually has a different SharePoint URL, so the first step Source will have to point to another URL.
Good pickup Nick
Great video, and nifty workarounds. Thanks for sharing!
Thanks Nick
Best video I found so far on RUclips
Thanks for letting me know 😀
I LOVE YOUR LESSONS ..PRACTICAL
Thank you
Excellent video and clearly explained. Thank you
You’re welcome. Thanks for taking the time to leave a kind comment
I always learn something new from your videos!
Thanks for letting me know 😀
Thank you, thank you, thank you for making this video, so incredibly helpful!
You’re welcome
Love the column width hack!
Thanks, it turns out you can just double click on the edge !!
This video helped me save many hours of waiting! Thanks!
You’re welcome Ida. Thanks for letting me know it helped
I just want to say that your video has helped me. thank you
Thanks for taking the time to leave a kind comment Bea
Thank you so much for the detailed tutorial! Your explanation makes it easy to understand!
You’re welcome
This video save my time and money. Many Thanks!
Glad to help 😀
well presented, clear and knowledgeable tutorial
Thank you
Second time this has saved me at work. Thank you, Sir!!
Glad to help Joshua 😀
Thanks Wyn! Always useful and interesting tips. Thumbs up!!
Thanks Wayne
This is exactly what I needed! Thank you!!
You’re welcome.
It was easy to follow. I feel successful after doing this.
I’m glad you found it useful
Thanks for sharing. You made my day. With standard method it is a pain if a SharePoint has 10000s of files....
Totally Frank. Glad to help
Awesome way to do it. Thanks so much for sharing it. This will be a great way for our team to share data easily.
Glad to help Dan
Great..., this is what i'm looking for, Thank you
Glad to help
Thankyou so much , you saved countless hours!!!!!
Great to hear! Thanks for taking the time to let me know
Thanks for sharing Wyn. Very useful content in this vídeo!
Thanks 😀
your video helps me save a lot of time.... thank you so much
Happy to help
Great video, put's light in a very complicated mechanism to access excel files. once again this proves how bad this non-feature was implemented from PowerBI point of view. The casual player will never figure out this. It has no explanation why power bi developers and sharepoint developers didn't manage to find a simple and easy way to access each specific folder !
Agreed. In the next 6 months I expect to see the dataflow UI hit power bi desktop and that has a better connector experience
Thank you so much for sharing this took some finding and several other methods are not so effective
You’re welcome
Excellent Wyn, I’ll be using this for sure 👍
Cheers Brad
Great video! You explained this to me in comments of another video of yours not too long ago, saved my life 😁
Glad to have helped Eddie. I’ve had similar questions multiple times recently so it was overdue for a video 😀
Very useful. I'll be updating my steps tomorrow 😄
That’s great to know, thanks for commenting! 😀
This is so much cleaner than my "filter 'ends with'" hack
Also seems to load waaaay faster, which is my biggest gripe with PowerX and SharePoint
Yes, definitely quicker as t doesn't have to navigate all that meta-data
Very useful video. Thanks a lot Sir!
You’re welcome Shafiq
Wow. This vidoe just transformed by process in a significant want, because my files are too large to have in a folder on my desktop. So i store my files in SharePoint and connect to folders to dynamically load the data
Thanks for taking the time to let me know it was useful
Awesome contribution. you saved my tons of hours. Thank you soo much
I appreciate you taking the time to let me know you found it useful
This is brilliant. And explained so logically!!!
Thanks for taking the time to leave a kind comment Amrita
Freaking Awesome! Thank you. As a beginner this is extremely helpful
You’re welcome
Great video - well paced explanation.
Thanks
Brilliant, just brilliant thanks so much 👍🏽👍🏽
☺️. Thank you
Bless you sir saved me a lot of headache
You’re welcome Ian
Very helpful! Can you explain how to combine Source and Navigation in one step and add to parameter as source
Thanks, you’d need to go into the advanced editor for that and combine the 2 steps into 1 and replace the path with a word like SourcePath, then create a parameter ( via parameter button ) called SourcePath
Great video! Learned something new! Thank you!
Cheers for the support Cristian
Thank a lot for sharing. extremely useful content.
You’re welcome Thuy Tam Dang
You’re welcome Thuy Tam Dang
Very good video, helped me on import data from Excel and csv files hosted on Sharepoint folder. Appreciate it very much.
However, this video is misleading to me as the formats of my Excel and csv files are different so do need to be consolidated.
So I suggest you change the title to add "consolidate" in it as quite some contents in this video is about "consolid" your 3 excel files.
Again, thank you for your video, expecially the tricks in it.
If you’re connecting to individual files I’d recommend ruclips.net/video/vPV67RLGoOg/видео.htmlsi=whWP7aSIWmeKw_4x
This was incredibly helpful, thank you so much!
Glad to help Elyse, thanks for taking the time to let me know it was useful
Thank you so much, this has been bothering me for such a long time. I don't understand why MS does not just allow you to connect to the subfolder directly instead of only allowing you to conect to the main Sharepoint site.
You're welcome, hopefully they'll improve it soon
Thanks for the video. It's informative and usefull.
I appreciate you taking the time to let me know you found it useful
Worked like a charm. Thank you sir.
I appreciate you taking the time to let me know you found it useful
Amazing stuff! Thank you.
Thanks Steve
Excelent! Clear and concise!
Thanks 😃
At least 3 good tips here I didn’t know,
Glad to help out Donald. The breaking out of the navigation step was something I came across accidentally a few months ago. Really handy in when referencing dataflows too.
This is excellent. Thank you so much!
You’re welcome
Awesome trick. You saved my day.
You're welcome 😄
Thanks for the wonderful tips. Could you also show how to get all the data if the Excel files contain multiple worksheets? Thanks
Consolidating multiple sheets from one file is here : ruclips.net/video/cPN24NK3_68/видео.html
Consolidating multiple sheets from multiple files is tricky. Likely multiple “ from folder “ queries or the use of custom functions
@@AccessAnalytic Thanks for the quick reply and appreciated the info.
No worries
thank you so much!!! I wish you get good & blessing karma because of your very useful knowledge!!
Thank you
Cool, liked this one. Helped me a lot
Great to know, thanks
Such a good tutorial ! Thanks a lot !
You’re welcome. I appreciate you taking the time to let me know you found it useful
Thanks for nice and simple way of explaining it. How can I dynamically pass SharePoint Link and Folder as a parameters so that we do not end-up rebuilding query every year or if same wants to use by multiple department but map with different SharePoint Site and Folder
Technically you can add a Parameters in Power Query (there's a button and wizard to create a parameter) then just replace the hard coded paths with the folder names. The difficulty with the SharePoint.Contents approach is there is an unknown number of folders to drill through so that will be a problem.
Great help, thanks a lot!
Glad it helped!
This is a great video! Exactly what I was trying to do. Question if I delete data on my PBI will it remove it from the sharepoint file?
Thanks. Power BI is read-only so filtering out any data in Power Query will have no impact on your SharePoint files
One of the spreadsheets had a table under the other. Now, in PBI I have two different data in one query. Can I remove half of the table into a new query, and would it keep its connection?
Difficult to answer without going into more detail but you can right-click reference a query and build other queries off it.
Thanks for this it will save me so much time! If the resulting file is to be shared by a group of people (within the same organization) do they all have to do the 'sign in' step? It seems unnecessary and inconvenient since they can already access the documents in sharepoint. Is there no way around it?
No worries John. Yes they all have to sign in, I know what you mean though.
Game changer. Thank you so much!!!
You’re welcome
Thank you so much tha was so helpful i solve my problem , love you man
☺️ glad I could help 🤘🏼
Wow!!! This is Awesome! Your going to save me hours now!
Excellent. I appreciate you taking the time to let me know you found it useful
Hi, great video. What do we do when we have multiple sheets ?
This video from Mynda might help
ruclips.net/video/sLW3NbeGDy8/видео.htmlsi=706iHhbc3WJ1IiBf
Incredible, thank you so much!!!!
You’re welcome
Great video ❤. Thank you.
You're welcome
Thanks a lot for all your videos, incredibly clear and helpfull !
I was wondering, if I need to import only one or two files on a sharepoint, should I use preferably this connection to the sharepoint folder method or the simple web connection to the file directly? which one is the more efficient? thanks:)
You’re welcome. Use from web when connecting to 1 file.
you are now my hero! Thank you
☺️ Glad to help.
Thank You!!!!! This is so helpful
You’re welcome 😀