Skip to main content

    Power BI

    New

    system variables available in Power Query

    Vote (9) Share
    Alex Apolloni's profile image

    Alex Apolloni on 10 Sep 2015 16:16:40

    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.

    Comments (1)
    Alex Apolloni's profile image Profile Picture

    72297824 86e1-4485-8247-57b4a9c3964a on 05 Jul 2020 22:33:43

    RE: system variables available in Power Query

    Hello,
    I agree that it is necessary, In VBA use Environ () .
    As it is called in Power Query?
    Thank you,
    Luisg