Am trying to get output in Power Automate as only "Mv_somethingunkown", while just searching as Mv as the array will be dynamic and after Mv the text will be changed everytime.
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?
In Power Automate, within the Power BI connector, you'll find the "Run a query against a dataset" action. Take note: this can only return one table at a time with max of 1,000 rows.
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 ?
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.
Use your mobile device to unlock or edit a file that another user has locked for editing.
Unlock a file that has been locked for editing - Microsoft Support
You are trying to open an Excel file and you get a message about the file being locked. Sometimes the file is locked by another user, and other times the "another user" is actually you. If you have locked the file yourself, it might be because the file is open on a different device, or the previous instance of the file didn't close properly.