Is this just part of the building process? Or If I have one query A that loads across the network and 5 follow up queries that refer to query A will power query / excel be reading the across the network 1 time or five times? What is the proper way in Power Query to refer to an existing query and reduce data pulls across the network?

Understanding the Context

Power Query code to refer to another query (and how buffering works) I'm working on a Power Automate flow that updates items in a SharePoint Online list. However, I'm facing an issue where certain columns (including Person/Group fields) are not appearing in the "Update item" action. You are confusing Power Automate with Power Automate Desktop. The link you provide is for Power Automate, so those functions won't work in the PADesktop.

Key Insights

There is an action named Convert datetime to text in PAD, you can specify the formats you would like there The action lets you pick from existing formats or you can specify one. copy this code to PAD to see a custom example Text ... I signed out and in multiple times in "power automate". I also opened the "sharepoint app" in Office365 (whatever you're supposed to do with it) which worked fine. The sharepoint connector in power automate also seems to be happy: Any ideas how to get the sharepoint connection running again ?

Final Thoughts

Both approaches work OK in Power BI desktop report, However once I published to Power BI service and after several refreshes (initially it was NZ time), the time turn back to UTC time. I don't want to create extra columns in DAX and really want to try use Power Query. Is there any way to work it out? Power Automate doesn't have a feature to allow you to refresh connections or open/close a document. I was also encountering the issue of the document not refreshing on "open" because it was locked by another user (due to using One Drive). I couldn't use Power BI, scripts, or MACROS either.

I needed my workflow to add rows to a spreadsheet, update the pivot tables, and then send an email with ...