Thanks for the Video. I want to use all files from a specific folder. I found the foulder in sharepoint but couldnt get to the colums from the file itself. can you help me with that? thanks in advance
I have over 15,000 records in my SP list; can I filter - using PowerQuery - the data before it all comes into my Excel file? Out of those 15,000 lines, I may only need 5 records most of the time.
Hello there, i have been using the power query for quite sometime , can you please tell how to extract if the sharepoint list have more than 5000lines in it? it throws error
I believe one of the connectors has 5000 row limit. I’m not sure about the other. You could try using an ODATA connection if the native SharePoint connectors aren’t working.
The Excel to SharePoint connector was deprecated ~2010. You have to setup IQY to get data from SP into Excel, and then use Power Flow to get Excel data back into SP. Think of it as MS job security, where once it was easy, then became hard.
Microsoft made some changes. Not sure when, but only Office 365 For Enterprise (O365 E3/E5 licenses) have the ability to get data from SharePoint. I have an E3 license and when I log into Excel on another user's computer who only has the business license, I get the option to Get Data from Sharepoint, but the moment I sign out and the regular user without the Enterprise license logs in, it disappears from the menu. Capitalism, at its finest.
Hey Jim, so is the only option to upgrade to office 365 for enterprise? This is a major obstacle for me at the moment for creating automations from my SharePoint lists.
