Questions tagged [power-query]
The power-query tag has no summary.
6 questions
0
votes
0
answers
21
views
Sharepoint REST API Paginatyed Query in Power BI retuning 404 errors for rows where data exists in SharePoint list
I am running a query in Power BI on a large SharePoint list of over 10,000 rows. In preview everything works but when I attempt to load the table, I get 404 errors in my data for rows where I know the ...
0
votes
0
answers
93
views
SharePoint list: Power Query only returns records Created By me
I have a SharePoint list where I am the owner with full access and I see all records in the web frontend. I have enabled item-level permission for normal users ("Read, create and edit items that ...
0
votes
1
answer
40
views
Explain SP authentication please
I operate in an environment that has thousands of SharePoint sites. And I need to get a list of all the site "Titles".
My approach has been to use PowerQuery in an Excel workbook calling ...
- 193
1
vote
0
answers
108
views
Execute several ODC (Power Query) and store output file
This may be an X/Y problem. Everyday reports are uploaded on an external SharePoint I have access to.
Everyday, I have to manually download the reports, work on them and save as new updated individual ...
0
votes
0
answers
173
views
How to automate incoming emails with Power Platform to notify and visualize tabular information with PowerApps?
I am trying to automate the incoming mail with Power Automate so when a mail arrives with a specific subject I extract the data and save it in an excel file. Power Apps would have this excel as a data ...
1
vote
1
answer
76
views
How do I acquire a single SharePoint page in PowerQuery?
This page - Site Contents - would be really useful to me:
https://......sharepoint.com/sites/....../....../_layouts/15/viewlsts.aspx?view=14
I want to pull this table into a excel sheet by means of ...
- 193