Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
alpines47
New Member

Need help having two, or more, users execute a power query

We have a complex Excel file performing an analysis of a customers data. The data is downloaded as an Excel file from a database. When one of us downloads the data the file is stored in a customer folder we all have access to on our shared Team Sites. The folder location and file name stay the same every time. Then, we have the analysis file in the same shared folder. When one of us builds a Power Query to get the data from the source file and load it to the analysis file it works just fine. But only the person who created the query can run it. If someone else on the team opens the file they can see the queries but cannot execute them. We get an error that says that part of the path cannot be found. When you look at the path it has the user name in it for the person who created the query. We are assuming that is the problem. Is there a way around this, or some fix? It seems crazy that everything is in a shared folder on a shared site but only the query creator can execute a query after it is built.

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @alpines47 ,

 

Check this video it will help you with your case.

https://www.youtube.com/watch?v=XIq5vN5oPf8&t=89s

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thank you for the help, but it did not quite solve my problem. It may be that I simply do not understand how to set up a dynamic parameter. Following the video I can now easily change the path so one of us can set-up a query and then another team member can edit the path and execute it. But we still need to edit the path. Our user name is in the path and that seems to be the problem. Whatever he is doing in the video does not seem to get me past that problem. When I get to the point of doing the drop down from the parameter icon the choice of parameter is already selected, so I cannot follow him from that point forward.

 

At this point I would say we are half-way home, but I am still shocked that a query set up to get info from a source file can only be executed by the user that set up the query? In other reading I have done people seem to suggest that anyone opening a file can execute a query that exists, but this does not work for us. We even turned on the feature to auto execute the query when the file is opened but even that only works for the person who created the query. This seems so stupid I keep thinking there has got to be something basic we are missing? Some permission setting?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors