All Questions
Tagged with power-query sharepoint
4
questions with no upvoted or accepted answers
1
vote
0
answers
341
views
Excel PowerQuery cannot find SharePoint files after a certain date
Background
I have a number of different Excel files which connect to a number of different SharePoint folders for a variety of purposes. Each week, new data is exported from our client systems and ...
- 11
0
votes
0
answers
94
views
Getting user names from a Sharepoint.files() extraction (Power Query)
From Sharepoint, I am able to extract a table containing filenames, file extensions, and dates...
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
However, I would like to ...
- 101
0
votes
1
answer
37
views
PowerQuery in Excel 'master' spreadsheet on SharePoint can only be refreshed by one user and gives authentication errors for others
I created a group of SharePoint libraries on an intranet that each contain an identically formatted spreadsheet, and another library that contains a “Master” spreadsheet that fills a table from the ...
0
votes
1
answer
177
views
Background Refresh Not Refreshing
I am pretty new to excel/power query, so I apologize if this is a basic question.
I'm using an Excel 16 document on sharepoint that is pulling data from another sharepoint document. The data queries ...
- 101