i was starting to lose hair over the frustration of being unable to connect to the sharepoint link. i had moved my entire organization from onedrive to sharepoint just to have a common path for power queries. thank you so much for posting this invaluable tutorial.
This is amazing, thank you for sharing! I have to say you make an excellent teacher. Very natural, coherent, interesting, correct pacing, nice voice, confident, intelligent and so on. I sound incredibly boring when presenting XD
This was baffling me for several days. on google there were so many confusing codes, but your video showed a much clearer and (comparatively) simpler way. this was really helpful, thank you so much!!
I wish I had seen this earlier! I spent nearly 100 hours, developing a naive Bayes classifier to solve a particularly tricky identity problem, to determine the proper primary key in a database. This would have been so helpful for my methodology. Awesome to see someone else using Excel for this!
Awesome! I've been using power query for years now and I just did not understand how to make the connection work by reading some tutorials online, you made it really simple. Thank you so much!
Hi mYnda, I have revisited this video of yours one again, as more and more , we are all using a cloud service ( onedrive in my case). You are definitively one of the best instructors and your knowledge is excellent. I wish you the best in your business and many thanks for helping us , in this ever increasing complicated world of IT. Kind Regards. Martin
This was The Best, I tell you, the best video on the topic, I saw few other before landing on this one, they were unnecessarily long and made complicated. I saw this, learnt what I wanted, implemented it successfully. Thank you my life saver :)
Thank you Mynda, I always wanted to perform PQ with a Teams shared file and I didn't know how. With your explanation in this video, I have solved it. This advice is very useful for me. Thank you
Mynda this video was perfect. Why Microsoft have decided to make OneDrive/SharePoint cloud integration into a key selling point feature such as Power Query so difficult and fiddly we can only imagine - hopefully the process becomes streamlined because even now after your excellent tutorial it is a daft amount of work when the On Premise solution is generally faultless.
Very useful. Bottom line Microsoft needs to make this a lot easier getting data from SharePoint. Especially since Power BI uses PQ as its principal ETL. Needing to faff about copying and pasting then editing links is not easy for the average worker who’s not used to data extraction.
Thank you, a very clear and easy to follow video which solved my challenge (changing the data source to the company's Sharepoint directory). I was even able to adapt Option 1 to work with CSV files too.
Really amazing! I can’t wait to try this! Been battling with SharePoint/ MS excel communication friendship for a while now. Seems like fun weekend is coming up😂. Love your content and thanx for helping me to be a better excel nerd 😀 Much Love! Martin
Thanks for the video. I'd like to load each of those Binary rows into a separate table rather than combining them into one single table because they all have different contents (columns and rows). I have saved all these tables in one path in a SharePoint. How to da that?
Each query generates a separate table. If you want your data in separate tables, then you have to create multiple queries, one for each table you want.
@@MyOnlineTrainingHub How to do that? When I click on the first binary row it creates a source and navigation and then if I want to create a second query for the second binary, I have to go back to the source but when I go back to the source and select the second binary row the first one disappears because the navigation step refers to the second binary row. I tried to add two lines of content an paths to load both binary lines but didn’t work.
@@MyOnlineTrainingHub So, possibly I should create a blank query for each binary source and copy the M code from each source to the blank query one by one and then delete the main query created from the SharePoint.
Hi! Thank you for your awesome videos. For some reason I do not have a "From sharepoint folder" option. I have a standard business 365 license. Is there a workaround if I do not have that option?
Excellent video, thank you for the detailed explanation. I'm unfortunately on Excel for 365 and the SharePoint folder connector is not available to me. I am migrating a workbook to get it's data from CSV's located in OneDrive but can't find for the life of me how to extract the "Last Modified Date" from the CSV using power query. Local files was easy enough but OneDrive files I cannot figure out, any thoughts on what I can do? Any help is appreciated.
Mynda, Thanks for another really useful video. In the example for getting data from a single file, you ended up opening the file in Excel but from OneDrive on the web. I understand this was to illustrate the different paths to the file. Forgive me for not testing this, (as I'm still watching), but do you have to open the workbook from the Web to get the correct path visible in Excel, or would it work the same way if you had opened it from OneDrive on your desktop?
Works great and did solve my problem. The only problem I have now is that it takes around 1 hour to scan and filter the proper files, there are only 300k records coming back but it is all the overhead on my OneDrive. I am thinking that I can ask IT to allocate a dedicated OneDrivethat I can use for this application and potentially other similar use cases, where it is not competing with 2TB of other files.
Update: I was able to put my data in a teams site, and since there are only a few files (lots of folders) it was very fast, under 20 seconds to run the Dax. Thanks so much!
Hi, at 1:50, my does not have the "Share", "Copy Path", or "Open File Location" choice above the "Protect Workbook" button as yours does. I have the Microsoft Office 365 ProPlus. Any ideas or work arounds?
Great! Thank you for this video! I now have to "re-map" 16 local files paths relations to OneDrive paths. 😵💫😵💫😵💫 My life was much easier before watching this video, I was assuming "nah, it's not possible" 😂😂😂
Massive thank you for this video, Mynda. I visualise data using PBI, but the source file and pbix are on my computer. They need to be accessible from our shared SP site. I have been unable to find the way to get the SP link issue to work, with numerous different error messages. I was maybe, 80% there, but not there! This vid has been invaluable in showing the way. Who knew! Thanks.
Hello Mynda Thanks for the walkthrough I am trying to use this with OneDrive Personal not organizational, but I don't get the option to copy path under the File name _or any options_ do you have any idea ?
Awesome video, thank you. What would happen if later on, one or more columns be added, deleted or renamed from the original date file and how we can update the Power query to reflect the changes and/or fixing error messages which will occur during refresh? Thanks
Thanks, Moe. If columns change that Power Query is relying on then it will break the query and you'll have to edit the steps either in the advanced editor or formula bar so it knows the new names/columns.
Hey, thanks! great video. I just have one question, when I try to open the file with a data source in the browser I am not able to refresh the data. Is it possible to use power queries in excel online?
Hello, thanks for this enlighten video. My excel app does NOT have (in GET DATA/ from File/) the option FROM SHARE POINT FOLDER. It only has FROM FOLDER (plain). Is that something my version of Excel is missing or is something related to the Excel configuration that I need to set?.
Thanks for this solution I was looking for. There is still one problem I want to solve. Is there any solution for refresh the data? If I refresh the data it takes very long instead refresh the data on the C location.
Hello, thank you for posting. I have a question. Since I am using a link from the sharepoint if I modify the file within the query will this be modify also in the sharepoint route?
Hello! Thank you so much for the video. It works. However, I have a report published and it is automatically refresh but it seems to have problems refreshing the Sara form the folder because it is attached to my user. Is there any way to fix this ?
Hi, Excellent work on it. May I ask if can I connect to someone's sharepoint folder that has been shared to me including the sub-folder and sub files. Because here you have query it successfully as it is your own sharepoint folder but what if it is not your sharepoint folder? Makes sense? Additional on it, I want to query also the version history of the sharepoint folder and files which I do not own but has just shared to me. Thanks!
Hi John, you can certainly refresh queries authored by the owner of the folder if they've given you permission, so I'd expect it you have permission to view the folder and get the necessary links, then you could also author the query yourself.
@@MyOnlineTrainingHub Hey, I tried it using Get data>SharePoint Folder but I it continue to connect even if I have successfully sign in. Can you please show us how? I appreciate your feedback! Thanks!
Great video! Thank you! QQ - is it possible to do something similar to get the library folders, sub folders, files within the sub folders and the custom columns they are categorised under? EG, Status, Assigned to etc. I want a view of the various doc in my library and their classifications but cant seem to find a solution. I can of course export directly out of sharepoint but trying to automate. Any help appreciated :D
Good question. I'm not sure about getting the metadata from SharePoint. It looks like it brings in some information like Date Created, Date Modified, so you may be able to get this other information too.
@@MyOnlineTrainingHub I think I have found a relatively good solution. The export to excel function in SP actually runs as .iqy. So this can be connected to an excel file for each section of the library needed. Granted, I can only refresh the data upon opening the excel file, but might be able to get around this with PowerAutomate! 😄
Thanks for the reply both personal Onedrive and work Onedrive files are synced to hard drive with AutoSave On. Just found it interesting that I can have work Onedrive files open in excel on either the desktop or browser open and still sync the related query but not on personal Onedrive. Was just interested to see what your and other users experience was to see if this was just something I was experiencing and others not.
Hi , at 6:57, i have 46 files different format I do not want to combine and merge but I want to open all in different sheets, but "06:57", I m l clicking at Binary and it can open one file and when i click on second file "binary" its replacing the first one, any suggestion
Thank you for the great content! Like other viewers, I've referenced this video several times when trying to extract data from a Sharepoint list. While it isn't explicitly covered, the principles are the same. In the process I've discovered that not every field in a list will come across in the extract. Most frustratingly, this happens to a field that contains a name that resolves to an entry in the Active Directory Global Address List. I've created a workaround but would be open to hearing about any solution to this.
Thank you for sharing and the great step-by-step directions to get a list from SharePoint. Is there a way to run scheduled tasks to get data from the SharePoint list? I want to get data from a SharePoint list once or twice a data into a database.
You are my heroine, that I searched for long time and no one at work had a clue.
So pleased I could help, Markus :-)
I was trying to figure this out for a week until i came across your video. Youre a life saver.
Glad I could help 😊
You are GREAT!!! It took one week for our IT team not to solve my problem, only 2 minutes from this video solved this!!! Thank you!!!!
Glad it helped!
@@MyOnlineTrainingHub Hello, how can I get the file name as a separate column if I am exporting the data from SharePoint folder?
This tutorial saved my job!! I don't have enough words to say THANK YOU SO SO MUCH!!! You have blessed my life 😇
Wow, that's awesome to hear, Javier!
Lots of tutorials, none as simple and easy to follow like yours. Thanks a lot!
Thanks so much!
i was starting to lose hair over the frustration of being unable to connect to the sharepoint link. i had moved my entire organization from onedrive to sharepoint just to have a common path for power queries.
thank you so much for posting this invaluable tutorial.
I'm so glad this solved your problem! It's a common pain point.
This is amazing, thank you for sharing! I have to say you make an excellent teacher. Very natural, coherent, interesting, correct pacing, nice voice, confident, intelligent and so on. I sound incredibly boring when presenting XD
Wow, thank you so much!
The way you walk through this is amazing. So simple and I just need to find you when I get stuck. Every answer I find through you. Thank you so much
Glad I could help!
This was baffling me for several days. on google there were so many confusing codes, but your video showed a much clearer and (comparatively) simpler way. this was really helpful, thank you so much!!
Glad it helped, Lauren!
I wish I had seen this earlier! I spent nearly 100 hours, developing a naive Bayes classifier to solve a particularly tricky identity problem, to determine the proper primary key in a database. This would have been so helpful for my methodology. Awesome to see someone else using Excel for this!
So pleased it was helpful, Joshua!
Was asking for ages how to get the proper URL and nobody could tell me. This video answered the question in 5 minutes - Thank you!!!!!!!
So pleased I could help!
Awesome! I've been using power query for years now and I just did not understand how to make the connection work by reading some tutorials online, you made it really simple. Thank you so much!
So glad it was helpful! 😊
crisp, clear and to the point. Much appreciated
Glad it was helpful!
Hi mYnda, I have revisited this video of yours one again, as more and more , we are all using a cloud service ( onedrive in my case). You are definitively one of the best instructors and your knowledge is excellent. I wish you the best in your business and many thanks for helping us , in this ever increasing complicated world of IT. Kind Regards. Martin
Thanks for your kind words, Martin!
You provide a tremendous service. This video enabled access to the centralized data files by my MS Teams members---and saved the day. Thank you.
Wow, that's awesome to hear, Mat!
Power Query and SharePoint. Relax and action! What a powerful tool!! Thank you Mynda.
You are most welcome, Ivan!
Thank you ... I needed to watch only the first 2 minutes to find what I was trying to do in the last 2 hours...
Glad it was helpful 😊
I was just a µ before giving up.
Thank you for the solution and the good channel.
Glad I could help!
This video is a saver to me, I was unable to get an idea to what extent I need to copy the SharePoint URL. Thanks a ton.
Glad it was helpful!
I didn’t even know this was an issue as I’ve never needed someone else to do a refresh. Thank you! I’ll know for the future.
You're welcome!
omg u literally changed my life from now on
So pleased this video was helpful 😊
Thank you Mynda, Power Query is a very important tool and you make this tool easy to use step by step. We appreciate your effort.
Thanks for watching!
Struggled with this for soooooo long. Thank you!
Glad it helped!
This video is gold in times of desperation. I was looking for this content, thank you very much!
I will subscribe
Glad I could help, Andres! Thanks for subscribing 😊
This was The Best, I tell you, the best video on the topic, I saw few other before landing on this one, they were unnecessarily long and made complicated. I saw this, learnt what I wanted, implemented it successfully. Thank you my life saver :)
Wow, thanks!
The video I was looking for the last few days. Thank you a ton, Tracy. Keep Rocking.
Glad it was helpful!
I cant thank you enough for what you are doing!
You are really helping us raising the bar!
So pleased to hear that 😊
Thank you, the explanations are very clear and easy to understand.
Glad to hear that!
Excellent! This came a the most appropriate time because I have been struggling with this.
So pleased to hear that, Patrick!
Thank you Mynda, I always wanted to perform PQ with a Teams shared file and I didn't know how. With your explanation in this video, I have solved it. This advice is very useful for me. Thank you
Awesome to hear, Miguel!
This is exactly what I was looking to learn how to do. Thank you.
Glad I could help.
I've been trying to find how to do this for months! Endless thanks!
Fantastic :-)
Mynda this video was perfect. Why Microsoft have decided to make OneDrive/SharePoint cloud integration into a key selling point feature such as Power Query so difficult and fiddly we can only imagine - hopefully the process becomes streamlined because even now after your excellent tutorial it is a daft amount of work when the On Premise solution is generally faultless.
Yes, I agree it could be easier.
Thank you so much! I have no words to describe how helpful this is
You're very welcome, John!
Thank you. Just what the doctor ordered
Glad I could help 😊
Best as always....thank you for the content you create and share. It really helps me on daily basis
Happy to hear that!
Thank you so much for this video. It has solved a massive headache for me 😊
Glad it helped!
What an amazing video, simple and intuitive. Thank you so much!
Glad you enjoyed it, Jorge!
Thank you so much for this video. Took me ages to find a solution!
Glad I could help 😊
Really great video, first one that solved my problem of drilling to proper SharePoint folder in my Power Querry. Thanks!
Great to hear!
Awesome tip!!!
Thank you, I've been trying to do this for months.
Happy to help, Michael!
Well prepared video Lynda. Keep working with such enjoyment and enthusiasm!
Thanks so much, Sachin!
Very useful. Bottom line Microsoft needs to make this a lot easier getting data from SharePoint. Especially since Power BI uses PQ as its principal ETL. Needing to faff about copying and pasting then editing links is not easy for the average worker who’s not used to data extraction.
I agree, it could be much easier!
Thank you, a very clear and easy to follow video which solved my challenge (changing the data source to the company's Sharepoint directory). I was even able to adapt Option 1 to work with CSV files too.
Glad it helped, Craig!
思路清晰，内容实用。老师很棒🔓
Thanks so much, Charlie 🙏
Really amazing! I can’t wait to try this! Been battling with SharePoint/ MS excel communication friendship for a while now. Seems like fun weekend is coming up😂. Love your content and thanx for helping me to be a better excel nerd 😀 Much Love! Martin
Glad it was helpful, Martin!
Fantastic! Very well and pleasantly explained
Thanks so much!
This is wonderful, thank you for sharing! you are a excellent coach.
Thanks for your kind words 🙏😊
Finally I found the video I wanted! Thanks for sharing this usefull content
Glad it was helpful!
Very useful when we are working with team
Glad to hear that!
You´re amazing with the explanation, in other hand microsoft are so burocratic that hurts
Thank you!
You're amazing. We appreciate the high quality content.
Great to hear 😊
Thanks for the video. I'd like to load each of those Binary rows into a separate table rather than combining them into one single table because they all have different contents (columns and rows). I have saved all these tables in one path in a SharePoint. How to da that?
Each query generates a separate table. If you want your data in separate tables, then you have to create multiple queries, one for each table you want.
@@MyOnlineTrainingHub How to do that? When I click on the first binary row it creates a source and navigation and then if I want to create a second query for the second binary, I have to go back to the source but when I go back to the source and select the second binary row the first one disappears because the navigation step refers to the second binary row. I tried to add two lines of content an paths to load both binary lines but didn’t work.
@@MyOnlineTrainingHub So, possibly I should create a blank query for each binary source and copy the M code from each source to the blank query one by one and then delete the main query created from the SharePoint.
Yep, it's tedious!
Very useful . Have been searching for this for quite a while. 👍
Glad it was helpful!
Thank you, Linda! You're awesome!
Glad it was helpful 🙏
I'm strulling with the content. Thanks a lot.
My pleasure!
I got it, thank you, at 2:45 i choose Organizational account tab for logging in cuz share point file is in limited access.
Amazing video, you've saved me few hours ! Thank you for sharing !
Great to hear!
Thank you, again, for being an excellent resource for solving these data query challenges :)
My pleasure 😊
Hi! Thank you for your awesome videos. For some reason I do not have a "From sharepoint folder" option. I have a standard business 365 license. Is there a workaround if I do not have that option?
The SharePoint connector is only available with a Microsoft 365 Apps for Enterprise license. You would have to upgrade your 365 license.
You’ve been a great help in making me learn and improving my productivity. Thank you so much ❤️
Great to hear, Zakaria!
Excellent video, thank you for the detailed explanation. I'm unfortunately on Excel for 365 and the SharePoint folder connector is not available to me. I am migrating a workbook to get it's data from CSV's located in OneDrive but can't find for the life of me how to extract the "Last Modified Date" from the CSV using power query. Local files was easy enough but OneDrive files I cannot figure out, any thoughts on what I can do? Any help is appreciated.
The SharePoint connector is only available in Excel 2019/2021 Professional Plus and with a Microsoft 365 Apps for Enterprise license.
Thanks great content as always! Also love the tips about sharing it at "11:56 Sharing Files with Others"
Glad it was helpful!
Thank you. I have learned so much on this video.😊
Awesome to hear 🙏
Thank you so much...but I am stuck at 4:36....mine shows only share point list not share point folder ...plz help me on this
Sounds like you have a version of Excel that doesn't have the right connector.
Thank you! clear and to the point as always
Great to hear!
I learn a lot. Thanks for your sharing.
My pleasure!
very important lesson thank you Myanda - Mohamad form Lebanon
Glad you liked it!
This is awesome. Thank you for posting this video.
My pleasure 😊
It’s really very helpful for me, thank you so much for this, i got exactly what I’m looking for. 👍
Awesome to hear!
Mynda, Thanks for another really useful video. In the example for getting data from a single file, you ended up opening the file in Excel but from OneDrive on the web. I understand this was to illustrate the different paths to the file. Forgive me for not testing this, (as I'm still watching), but do you have to open the workbook from the Web to get the correct path visible in Excel, or would it work the same way if you had opened it from OneDrive on your desktop?
Thanks, Simon! Yes, you must open the file from OneDrive on the web in order to get the correct path to the file.
Works great and did solve my problem. The only problem I have now is that it takes around 1 hour to scan and filter the proper files, there are only 300k records coming back but it is all the overhead on my OneDrive. I am thinking that I can ask IT to allocate a dedicated OneDrivethat I can use for this application and potentially other similar use cases, where it is not competing with 2TB of other files.
Update: I was able to put my data in a teams site, and since there are only a few files (lots of folders) it was very fast, under 20 seconds to run the Dax. Thanks so much!
Wow, awesome to hear, Don!
Thanks a ton Mynda! I was just looking for this and got the best to solve my problem! 😊👍
Glad it was helpful 😊
Wooow! Just what I've been looking for! Thanks!
Great to hear, Sergio!
Thank you so much! Your video helps with my work. ❤
So great to hear!
Hi, at 1:50, my does not have the "Share", "Copy Path", or "Open File Location" choice above the "Protect Workbook" button as yours does. I have the Microsoft Office 365 ProPlus. Any ideas or work arounds?
Hmmm, I suspect your IT people have turned off sharing functionality in your version of Excel. I'd take it up with them.
Great! Thank you for this video!
I now have to "re-map" 16 local files paths relations to OneDrive paths. 😵💫😵💫😵💫
My life was much easier before watching this video, I was assuming "nah, it's not possible" 😂😂😂
😆 it’ll be worth it!
Massive thank you for this video, Mynda. I visualise data using PBI, but the source file and pbix are on my computer. They need to be accessible from our shared SP site. I have been unable to find the way to get the SP link issue to work, with numerous different error messages. I was maybe, 80% there, but not there!
This vid has been invaluable in showing the way. Who knew!
Thanks.
So pleased it was helpful, Steve!
Hello Mynda
Thanks for the walkthrough
I am trying to use this with OneDrive Personal not organizational, but I don't get the option to copy path under the File name _or any options_ do you have any idea ?
It's not available for OneDrive personal.
Awesome! This is very helpful! Thank you for sharing!
You are most welcome!
Awesome video, thank you. What would happen if later on, one or more columns be added, deleted or renamed from the original date file and how we can update the Power query to reflect the changes and/or fixing error messages which will occur during refresh? Thanks
Thanks, Moe. If columns change that Power Query is relying on then it will break the query and you'll have to edit the steps either in the advanced editor or formula bar so it knows the new names/columns.
@@MyOnlineTrainingHub Thank you, I will give it a try.
Hey, thanks! great video. I just have one question, when I try to open the file with a data source in the browser I am not able to refresh the data. Is it possible to use power queries in excel online?
Not yet, but its coming.
Hello, thanks for this enlighten video. My excel app does NOT have (in GET DATA/ from File/) the option FROM SHARE POINT FOLDER. It only has FROM FOLDER (plain). Is that something my version of Excel is missing or is something related to the Excel configuration that I need to set?.
The from SharePoint connector is only available in Excel 2019 Professional Plus and with a Microsoft 365 Apps for Enterprise license.
@@MyOnlineTrainingHub Many Thanks!! That explains!. Now, can I still connect using VBA right?
Excelente video. Me ha sido muy útil. Muchas gracias
Tienes un seguidor más desde República Dominicana 😃
Gracias, Eliezer!
Thanks for this solution I was looking for. There is still one problem I want to solve. Is there any solution for refresh the data? If I refresh the data it takes very long instead refresh the data on the C location.
Hello, thank you for posting. I have a question. Since I am using a link from the sharepoint if I modify the file within the query will this be modify also in the sharepoint route?
Power Query doesn't/can't write back to the source files, so any editing you do in the query does not affect the original file.
Hello, great info but what about 365 business users , seems like Microsoft left out the SharePoint connector out , is there any work around? Thanks
No workaround, sorry. It's frustrating and we MVPs tell Microsoft all the time!
Hello! Thank you so much for the video. It works. However, I have a report published and it is automatically refresh but it seems to have problems refreshing the Sara form the folder because it is attached to my user. Is there any way to fix this ?
You need to give whoever is refreshing, permission to the file.
Well this helped a lot! Thank YOU for creating this video!!! :)
You're so welcome!
Hi, Excellent work on it. May I ask if can I connect to someone's sharepoint folder that has been shared to me including the sub-folder and sub files. Because here you have query it successfully as it is your own sharepoint folder but what if it is not your sharepoint folder? Makes sense?
Additional on it, I want to query also the version history of the sharepoint folder and files which I do not own but has just shared to me. Thanks!
Hi John, you can certainly refresh queries authored by the owner of the folder if they've given you permission, so I'd expect it you have permission to view the folder and get the necessary links, then you could also author the query yourself.
@@MyOnlineTrainingHub Hey, I tried it using Get data>SharePoint Folder but I it continue to connect even if I have successfully sign in. Can you please show us how? I appreciate your feedback!
Thanks!
Just what I was looking for
Glad I could help 😊
You are a life saver 😢
Glad I could help!
Very helpful. Thank you so much!
You're very welcome!
Superb content, thanks for your efforts
So nice of you 🙏
This is very useful to me. Thank you so much.
Glad to hear that!
Great video! Thank you! QQ - is it possible to do something similar to get the library folders, sub folders, files within the sub folders and the custom columns they are categorised under? EG, Status, Assigned to etc. I want a view of the various doc in my library and their classifications but cant seem to find a solution. I can of course export directly out of sharepoint but trying to automate.
Any help appreciated :D
Good question. I'm not sure about getting the metadata from SharePoint. It looks like it brings in some information like Date Created, Date Modified, so you may be able to get this other information too.
@@MyOnlineTrainingHub I think I have found a relatively good solution. The export to excel function in SP actually runs as .iqy. So this can be connected to an excel file for each section of the library needed. Granted, I can only refresh the data upon opening the excel file, but might be able to get around this with PowerAutomate! 😄
Thanks for the reply both personal Onedrive and work Onedrive files are synced to hard drive with AutoSave On. Just found it interesting that I can have work Onedrive files open in excel on either the desktop or browser open and still sync the related query but not on personal Onedrive.
Was just interested to see what your and other users experience was to see if this was just something I was experiencing and others not.
I can't have ODB or ODP files open and refresh queries.
Hi , at 6:57, i have 46 files different format I do not want to combine and merge but I want to open all in different sheets, but "06:57", I m l clicking at Binary and it can open one file and when i click on second file "binary" its replacing the first one, any suggestion
The only way to open multiple files in separate queries/sheets is to do it one at a time.
Thank you for the great content! Like other viewers, I've referenced this video several times when trying to extract data from a Sharepoint list. While it isn't explicitly covered, the principles are the same. In the process I've discovered that not every field in a list will come across in the extract. Most frustratingly, this happens to a field that contains a name that resolves to an entry in the Active Directory Global Address List. I've created a workaround but would be open to hearing about any solution to this.
I've not come across that problem before, Tom. Hope you find a workaround.
@@MyOnlineTrainingHub thanks. I would never rule out that it is something I am doing :) but it remains a mystery to me.
I'd probably give up and move the file to a location that's easier to navigate to 😂
Thank you for sharing and the great step-by-step directions to get a list from SharePoint. Is there a way to run scheduled tasks to get data from the SharePoint list? I want to get data from a SharePoint list once or twice a data into a database.
You can write some VBA to trigger the refresh automatically, but the file must be open for it to execute.