All Questions
Tagged with power-query sharepoint
7
questions
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 ...
3
votes
1
answer
4k
views
Power Queries in Excel just default to "anonymous" and doesn't ask for login info
I have created multiple Excel sheets for my coworkers, many of which involve power query connections to our corporate SharePoint site. When I set it up, I logged into my SharePoint account to ...
1
vote
1
answer
4k
views
How to allow multiple users to refresh to sharepoint Excel file with Power Query
I have an excel file with data and the second excel file that uses Power Query to connect and fetch data from that 'data' file. They both are located in the Sharepoint space.
When I set up a ...
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 ...
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 ...
0
votes
1
answer
2k
views
Power Query - how to connect to sharepoint list using VBA
anybody knows how to connect to SharePoint Folder using VBA for Power Query? I need to perform ETL(Extract,Transform & Load) process using Power Query, and would like to use VBA to automate the ...