Get Data From SharePoint or OneDrive with Power Query - Demystified! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Reinaldo
Thbak you very much for this tutorial Mynda. This is exactly what I was looking for. However, everything seems to be working for me, and it lets me get my data from my OneDrive folder from my organization, and Power query runs smoothly. But when I share the file and folder with my coworker, and he tries to run the query, he encounters an error that says -[Expression.Error] There weren't enough elements in the enumeration to complete this operation- And this appears no matter what we do. Do to know why this happens? It works perfectly for me but not for my coworker.
reply
Thbak you very much for this tutorial Mynda. This is exactly what I was looking for. However, everything seems to be working for me, and it lets me get my data from my OneDrive folder from my organization, and Power query runs smoothly. But when I share the file and folder with my coworker, and he tries to run the query, he encounters an error that says -[Expression.Error] There weren't enough elements in the enumeration to complete this operation- And this appears no matter what we do. Do to know why this happens? It works perfectly for me but not for my coworker.
reply
Ben
Hey! Thanks for your helpful videos.
My 'combine files' button is greyed out - do you have any idea why this could be?
For clarity:
- I am trying to merge 3 files.
- the files are stored in an online sharepoint/mysmartplace library
- I have followed the second option in your walkthrough (get data from SharePoint folder, filter down to the file sources I need)
- I merged followed these steps by selecting 'get data' in PowerBI, rather than excel.
Huge thanks if you can help,
Ben
reply
Hey! Thanks for your helpful videos.
My 'combine files' button is greyed out - do you have any idea why this could be?
For clarity:
- I am trying to merge 3 files.
- the files are stored in an online sharepoint/mysmartplace library
- I have followed the second option in your walkthrough (get data from SharePoint folder, filter down to the file sources I need)
- I merged followed these steps by selecting 'get data' in PowerBI, rather than excel.
Huge thanks if you can help,
Ben
reply
David
Thanks for this Mynda, any attempts to demystify MS platforms are most welcome, especiually in light of our recent transition from a non Microsoft platform. I have a related query I'm hoping you can clarify. If a Power Query folder can be uploaded to OneDrive and SharePoint, and that OneDrive folders can be shared directly across an institution, what would be the purpose for linking a folder/file/SharePoint in the manner you have demonstrated (ie connecting through a blank excel workbook)?
reply
Thanks for this Mynda, any attempts to demystify MS platforms are most welcome, especiually in light of our recent transition from a non Microsoft platform. I have a related query I'm hoping you can clarify. If a Power Query folder can be uploaded to OneDrive and SharePoint, and that OneDrive folders can be shared directly across an institution, what would be the purpose for linking a folder/file/SharePoint in the manner you have demonstrated (ie connecting through a blank excel workbook)?
reply
martin
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
reply
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
reply
Paweeya
I have a problem when I want to recall data from sharepoint again after I did not use it for a time. I use power query to pull data from sharepoint, but it always stuck at data do not allow to use, kind of my source were gone even though my first time there was nothing stuck. Could you please me find the solution about this?
Thank you in advance.
reply
I have a problem when I want to recall data from sharepoint again after I did not use it for a time. I use power query to pull data from sharepoint, but it always stuck at data do not allow to use, kind of my source were gone even though my first time there was nothing stuck. Could you please me find the solution about this?
Thank you in advance.
reply
Joshua
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!
reply
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!
reply
Sruthi
Great video. Thanks very much. But I've been looking for ways where I can retrieve data from Connection only queries rather than creating a connection with table, so when I share my file with external or 3rd party people, they would have access to the source files. Is there a way ? Please help.
reply
Great video. Thanks very much. But I've been looking for ways where I can retrieve data from Connection only queries rather than creating a connection with table, so when I share my file with external or 3rd party people, they would have access to the source files. Is there a way ? Please help.
reply
Rajeev
Great video Mynda, I've got it bookmarked because it's so useful! I have some clients that are not on the Enterprise apps edition so don't have a the Sharepoint connector. Is there an alternative way to connect to a Sharepoint or Onedrive folder for users who are on the 365 Business edition?
reply
Great video Mynda, I've got it bookmarked because it's so useful! I have some clients that are not on the Enterprise apps edition so don't have a the Sharepoint connector. Is there an alternative way to connect to a Sharepoint or Onedrive folder for users who are on the 365 Business edition?
reply
Andy
Excellent. Just what I need to do. But I can't get working. My Sharepoint site is quite large, and when I try to import it into the PQ I'm not getting a Table with one line per element. I either get nothing, or I get a relatively short table that doesn't include the path I want. Any ideas?
reply
Excellent. Just what I need to do. But I can't get working. My Sharepoint site is quite large, and when I try to import it into the PQ I'm not getting a Table with one line per element. I either get nothing, or I get a relatively short table that doesn't include the path I want. Any ideas?
reply
L.
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?.
reply
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?.
reply
Add a review, comment
Other channel videos
9:15
12:16
