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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

system variables available in Power Query

I'd like access to system variables like %userprofile% or %cd% or something like "the current directory that this file resides in" so that you can have XLS file with Power Query that then points to a separate file in the current directory...whether it's on your laptop or on a sharedrive. I have XLS with PowerQuerys that I'd like to share with people who might not have the knowledge to modify the queries.
Status: Needs Votes
Comments
Luis_guerman
New Member
Hello, I agree that it is necessary, In VBA use Environ () . As it is called in Power Query? Thank you, Luisg
fbcideas_migusr
New Member
Status changed to: Needs Votes