Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: May 30, 2025
Topics: 61 / Replies: 1572
Reply
RE: Power Query Paginating from Dataverse API Help

Hi Matthew, I don't get any errors with this code, I'd need your file to see how it is being executed against the data you are receiving. Typica...

1 year ago
Forum
Reply
RE: Data Model - Measures, functions showing multiple times

Hi Elle, I'm not following the problem. Can you supply some screen shots and maybe the file(s) You've posted in the Power Query forum but measu...

1 year ago
Forum
Reply
RE: In Microsoft Power Automate, is there a way to look at a previous version of a Flow?

Hi William, This is a Power Query forum, not Power Automate, sorry we can't help with this. Regards Phil

1 year ago
Forum
Reply
RE: What is the proper way to use the ' ' return character in a Power Automate Flow?

Hi William, This is a Power Query forum, not Power Automate, sorry we can't help with this. Regards Phil

1 year ago
Forum
Reply
RE: reporting in Excel

Hi Sam, If you found the response unhelpful I'd say that's because the initial question was vague. If you wanted to know if there is a forms build...

1 year ago
Topic
Replies: 1
Views: 104
Reply
RE: TextJoin by ID

Hi Dominic, No file attached. After selecting the file, click the Start Upload button and wait for it to upload fully. Phil

1 year ago
Reply
RE: FINDING MONTH

Hi, You haven't said what version of Excel you have. If you can use XLOOKUP try this =XLOOKUP(MAX(B2:K2),B2:K2,$B$1:$K$1) or with INDEX MATC...

2 years ago
Reply
RE: Web Connector Power Query to API

Hi Nicola, I can't reproduce any of your issues. If you click the link you pasted to the NASA API it returns JSON data. Therefore the error you...

2 years ago
Forum
Reply
RE: Web Connector Power Query to API

Hi Nicola, without your code I can't do much to help you. Phil

2 years ago
Forum
Reply
RE: Why is my COUNTIF formula taking 8 hours to run?

Hi Chris, Load your file to Google Drive or OneDrive and then post a link to it. Phil

2 years ago
Reply
RE: Forum List: unclear entries

Hi Ayal, I'm using Edge too but don't have that issue. Not sure why you are but I'll investigate. In the meantime, just use the frontpage of th...

2 years ago
Reply
RE: Investment Calculator

No file attached. Click the Start Upload button after selecting the file

2 years ago
Reply
RE: Querying Power BI dataset in Excel

Hi Mike, The connector only allows you to load the data into a table or a pivot table. You'll have to do that then load the table into PQ, do yo...

2 years ago
Forum
Reply
RE: Excel question about accessing a new worksheet through Checkbox feature

Hi David, You could use VBA but is that what you want? Maybe if you supply an example of what you are actually trying to do we can understand yo...

2 years ago
Page 5 / 109