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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Create a mutable global variable in M language

Hi, community, 

I'm working on a custom connector that needs to authenticate before data representation is done, and to do this I don't want to hardcode the auth credentials in my source code. 

 

So, I declared a global list variable named

 

config = {"a"};

 

 

and in the shared MyCustomConnector.Contents function, I'm doing a List.ReplaceValue on item "a" in the list above.

 

shared MyCustomConnector.Contents = (BaseUrl as text, ClientId as text) => 
List.ReplaceValue(config, "a", BaseUrl, Replacer.ReplaceText);

 

 

so in my StartLogin function, I can just call the config by index like this.

 

//Start Login
StartLogin = (resourceUrl, state, display) =>
    let

        AuthorizeUrl ="https://"&Text.From(config{0})&"/oauth/authorize?" & Uri.BuildQueryString(
            [
                client_id = "11",
                response_type="code",
                state = state,
                redirect_uri = redirect_uri
            ]
        )
    in
        [
            LoginUri = AuthorizeUrl,
            CallbackUri = redirect_uri,
            WindowHeight = windowHeight,
            WindowWidth = windowWidth,
            Context = null
        ];

 

 

But it appears that, the List.ReplaceValue is not being executed because whenever I try to set credential for authentication, "a" is being passed into the URL. 

 

Any help will be much appreciated

1 REPLY 1
lbendlin
Super User
Super User

Please read Ben Gribaudo's primer again.

 

Have a look at the meta data section too.

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors