This video is a genuine service to humanity

@AccessAnalytic

Жыл бұрын

😂 - made me smile - thanks!

@robm1010

Жыл бұрын

I agree 1000%. This video is gold and is something I never want to lose.

@AccessAnalytic

Жыл бұрын

Thank you 😀

@Fonzyrr

Жыл бұрын

@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?

@arisaleh1980

Жыл бұрын

I am just speechless. What an unbelivably timesaving workaround.

Even in 2024 this Video still makes me say : you are the Master !!!

@AccessAnalytic

Ай бұрын

Cheers Juan!

To be honest this video has just paid for my year's KZread 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.

@AccessAnalytic

4 ай бұрын

Very kind, I appreciate you taking the time to let me know you found it useful

Thank you! That was exactly what I was looking for! Finally I managed to connect with my subfolder on the Sharepoint.

@AccessAnalytic

9 күн бұрын

Great! I appreciate you taking the time to let me know you found it useful

Thanks Wyn! Always useful and interesting tips. Thumbs up!!

@AccessAnalytic

2 жыл бұрын

Thanks Wayne

Great video, and nifty workarounds. Thanks for sharing!

@AccessAnalytic

Жыл бұрын

Thanks Nick

Great video! You explained this to me in comments of another video of yours not too long ago, saved my life 😁

@AccessAnalytic

2 жыл бұрын

Glad to have helped Eddie. I’ve had similar questions multiple times recently so it was overdue for a video 😀

Thanks for sharing Wyn. Very useful content in this vídeo!

@AccessAnalytic

2 жыл бұрын

Thanks 😀

You are the only person who came with a decent solution that really works. Thanks!

@AccessAnalytic

11 ай бұрын

You're welcome

This is EXTREMELY helpful. Thanks very much for making this video.

@AccessAnalytic

2 жыл бұрын

No worries. Thanks for taking the time to leave a kind comment Sean

This is brilliant. And explained so logically!!!

@AccessAnalytic

Жыл бұрын

Thanks for taking the time to leave a kind comment Amrita

I always learn something new from your videos!

@AccessAnalytic

2 жыл бұрын

Thanks for letting me know 😀

Excellent Wyn, I’ll be using this for sure 👍

@AccessAnalytic

2 жыл бұрын

Cheers Brad

This was incredibly helpful, thank you so much!

@AccessAnalytic

2 жыл бұрын

Glad to help Elyse, thanks for taking the time to let me know it was useful

Thank you, thank you, thank you for making this video, so incredibly helpful!

@AccessAnalytic

Жыл бұрын

You’re welcome

MY GOD!!! Amazing! spent ages getting errors using other methods, love the simple exceptionally clear step by step presentation - Thank you!

@AccessAnalytic

Жыл бұрын

You’re welcome Neil. Glad it helped and thanks for taking the time to leave a kind comment

Absolutely brilliant! Thank you so much. Finding subfolders in SP has been a killer for me until now. Much appreciated.

@AccessAnalytic

Жыл бұрын

You’re welcome. I appreciate you taking the time to let me know you found it useful

Omg, finally found this! Agree, this is a genuine service to humanity

@AccessAnalytic

5 ай бұрын

Hah 😆, thank you

This video helped me save many hours of waiting! Thanks!

@AccessAnalytic

Жыл бұрын

You’re welcome Ida. Thanks for letting me know it helped

Agree with so many other comments! Thank you for sharing your knowledge in such a clear way! Many thanks!

@AccessAnalytic

4 ай бұрын

You’re very welcome. Thanks for taking the time to leave a kind comment

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!

@AccessAnalytic

2 жыл бұрын

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 😀

Excelent! Clear and concise!

@AccessAnalytic

Жыл бұрын

Thanks 😃

Excellent video and clearly explained. Thank you

@AccessAnalytic

Жыл бұрын

You’re welcome. Thanks for taking the time to leave a kind comment

Thank you. I have used your teaching from this video today.

@AccessAnalytic

Жыл бұрын

Thanks for taking the time to let me know it helped Julie

Thank you so much for the detailed tutorial! Your explanation makes it easy to understand!

@AccessAnalytic

6 ай бұрын

You’re welcome

Thank you for posting a better/quicker way to connect to sharepoint folder! It worked very well for me!

@AccessAnalytic

2 ай бұрын

You’re welcome

Finally! It was so hard to find such elegant solution to the problem of slow working with SPO folders...

@AccessAnalytic

4 ай бұрын

I’m glad you found it useful.

Great video! Learned something new! Thank you!

@AccessAnalytic

2 жыл бұрын

Cheers for the support Cristian

Thanks for solving puzzles for me. Love you man. You are great 👍

@AccessAnalytic

9 ай бұрын

Too kind ☺️

I LOVE YOUR LESSONS ..PRACTICAL

@AccessAnalytic

Жыл бұрын

Thank you

Second time this has saved me at work. Thank you, Sir!!

@AccessAnalytic

Жыл бұрын

Glad to help Joshua 😀

Great video - well paced explanation.

@AccessAnalytic

Жыл бұрын

Thanks

Awesome way to do it. Thanks so much for sharing it. This will be a great way for our team to share data easily.

@AccessAnalytic

Жыл бұрын

Glad to help Dan

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!

@AccessAnalytic

2 жыл бұрын

Absolutely Alex, I used to feel the same way

Very useful. I'll be updating my steps tomorrow 😄

@AccessAnalytic

2 жыл бұрын

That’s great to know, thanks for commenting! 😀

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.

@AccessAnalytic

11 ай бұрын

😀 thanks Matheus

Freaking Awesome! Thank you. As a beginner this is extremely helpful

@AccessAnalytic

Жыл бұрын

You’re welcome

Amazing stuff! Thank you.

@AccessAnalytic

Жыл бұрын

Thanks Steve

Very useful video. Thanks a lot Sir!

@AccessAnalytic

Жыл бұрын

You’re welcome Shafiq

I just want to say that your video has helped me. thank you

@AccessAnalytic

Жыл бұрын

Thanks for taking the time to leave a kind comment Bea

Holy c... - the speed on this solution is Amazing !!!! Instead of 5 minutes - I'm getting data in 30 seconds - Thank you very much !!!!!

@AccessAnalytic

11 ай бұрын

You’re very welcome and thanks for confirming the speed gains

Great..., this is what i'm looking for, Thank you

@AccessAnalytic

Жыл бұрын

Glad to help

well presented, clear and knowledgeable tutorial

@AccessAnalytic

Жыл бұрын

Thank you

Great help, thanks a lot!

@AccessAnalytic

Жыл бұрын

Glad it helped!

Brilliant, just brilliant thanks so much 👍🏽👍🏽

@AccessAnalytic

Жыл бұрын

☺️. Thank you

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

@AccessAnalytic

Жыл бұрын

Excellent!

Useful Wyn!!!!

@AccessAnalytic

2 жыл бұрын

Cheers Jorge

Thank a lot for sharing. extremely useful content.

@AccessAnalytic

2 жыл бұрын

You’re welcome Thuy Tam Dang

@AccessAnalytic

2 жыл бұрын

You’re welcome Thuy Tam Dang

Love the column width hack!

@AccessAnalytic

Жыл бұрын

Thanks, it turns out you can just double click on the edge !!

Great video ❤. Thank you.

@AccessAnalytic

Жыл бұрын

You're welcome

Just awesome! Ultimate trick!

@AccessAnalytic

2 жыл бұрын

Cheers Thomas

I wish I could give a x100 thumbs up. So useful for my job. Thanks

@AccessAnalytic

10 ай бұрын

Awesome!

Thank You!!!!! This is so helpful

@AccessAnalytic

Жыл бұрын

You’re welcome 😀

I've been trying to solve performance issues for a week!! I'd LOVE this video if I could

@AccessAnalytic

10 ай бұрын

Glad to help, thanks for taking the time to leave a kind comment

Awesome contribution. you saved my tons of hours. Thank you soo much

@AccessAnalytic

10 ай бұрын

I appreciate you taking the time to let me know you found it useful

Thanks for sharing!

@AccessAnalytic

Жыл бұрын

You're welcome

your video helps me save a lot of time.... thank you so much

@AccessAnalytic

Жыл бұрын

Happy to help

Cool, liked this one. Helped me a lot

@AccessAnalytic

8 ай бұрын

Great to know, thanks

Awesome trick. You saved my day.

@AccessAnalytic

Жыл бұрын

You're welcome 😄

Game changer. Thank you so much!!!

@AccessAnalytic

8 ай бұрын

You’re welcome

Awesome! Thank you!

@AccessAnalytic

Жыл бұрын

You’re welcome

Incredible, thank you so much!!!!

@AccessAnalytic

10 ай бұрын

You’re welcome

It was easy to follow. I feel successful after doing this.

@AccessAnalytic

2 ай бұрын

I’m glad you found it useful

It was so useful! Thanks!!!

@AccessAnalytic

Жыл бұрын

I appreciate you taking the time to let me know you found it useful

Worked like a charm. Thank you sir.

@AccessAnalytic

Ай бұрын

I appreciate you taking the time to let me know you found it useful

"Move to beginning" - Such a time saver

@AccessAnalytic

Жыл бұрын

Thanks 😀 All these little things help

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.

@AccessAnalytic

11 ай бұрын

You are welcome. I appreciate you taking the time to let me know you found it useful

Wow!!! This is Awesome! Your going to save me hours now!

@AccessAnalytic

7 ай бұрын

Excellent. I appreciate you taking the time to let me know you found it useful

Awesome- thanks a lot!

@AccessAnalytic

Жыл бұрын

You’re welcome

Thanks for sharing. You made my day. With standard method it is a pain if a SharePoint has 10000s of files....

@AccessAnalytic

2 жыл бұрын

Totally Frank. Glad to help

Thank you mate!

@AccessAnalytic

2 жыл бұрын

You’re welcome Alex

Thanks very much

@AccessAnalytic

Жыл бұрын

No worries

What an awesome hack! I can't believe Microsoft hasn't already baked the SharePoint.Contents functionality into their PQ menus. Thank you!!!

@AccessAnalytic

8 ай бұрын

You’re 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.

@AccessAnalytic

Жыл бұрын

Good pickup Nick

you are now my hero! Thank you

@AccessAnalytic

4 ай бұрын

☺️ Glad to help.

Best video I found so far on KZread

@AccessAnalytic

9 ай бұрын

Thanks for letting me know 😀

THANK YOU, THANK YOU, THANK YOU!!! 😃

@AccessAnalytic

2 жыл бұрын

You’re welcome Luz

This video very useful 😍

@AccessAnalytic

Жыл бұрын

Thanks!

Thanky you very much!

@AccessAnalytic

Жыл бұрын

You’re welcome

Bless you sir saved me a lot of headache

@AccessAnalytic

Жыл бұрын

You’re welcome Ian

Very helpful

@AccessAnalytic

Жыл бұрын

You're welcome Max

This helps! Thank you!

@AccessAnalytic

3 ай бұрын

You’re welcome

Brilliant!!!

@AccessAnalytic

Жыл бұрын

Thanks 😀

Thank you so much. this is very helpful

@renceyanyow

Жыл бұрын

I had issue where in I still have to open all excels file just to have an updated consolidated data.

@AccessAnalytic

Жыл бұрын

You’re welcome

@AccessAnalytic

Жыл бұрын

Could you explain a bit more about the need to open all the files

@renceyanyow

Жыл бұрын

@@AccessAnalytic this vid actually solves the problem. Because last time in order to have a live update on all table. I need to open all of them simultaneously so that i can refresh the data realtime.

@AccessAnalytic

Жыл бұрын

Great to know it helped

Very helpful video! thank you

@AccessAnalytic

5 ай бұрын

You’re welcome

Thanks sifu..u help me alot..

@AccessAnalytic

9 ай бұрын

I appreciate you taking the time to let me know you found it useful

Thank you so much for sharing this took some finding and several other methods are not so effective

@AccessAnalytic

2 ай бұрын

You’re welcome

BRILLIANT!!

@AccessAnalytic

Жыл бұрын

Cheers Adam

Amazing, thank you!

@AccessAnalytic

5 ай бұрын

You're welcome

Really useful

@AccessAnalytic

Жыл бұрын

Thanks

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 !

@AccessAnalytic

9 ай бұрын

Agreed. In the next 6 months I expect to see the dataflow UI hit power bi desktop and that has a better connector experience

Awesome, it worked ;)

@AccessAnalytic

Жыл бұрын

Great!

Thank you so much tha was so helpful i solve my problem , love you man

@AccessAnalytic

2 күн бұрын

☺️ glad I could help 🤘🏼

Thank you so much - amazing

@AccessAnalytic

4 ай бұрын

Thanks, I appreciate the comment

Bless you

Mil Gracias 🙏🙏

@AccessAnalytic

9 ай бұрын

No worries

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

@AccessAnalytic

Жыл бұрын

Yes, definitely quicker as t doesn't have to navigate all that meta-data

thank you so much!!! I wish you get good & blessing karma because of your very useful knowledge!!

@AccessAnalytic

8 ай бұрын

Thank you

Amazing! This is what I want. You saved my lifee haha

@AccessAnalytic

28 күн бұрын

Glad to have helped 😀

Great!

@AccessAnalytic

Жыл бұрын

Thanks Virginia