Forum Discussion

pawlowski6132's avatar
pawlowski6132
Helper V
5 years ago

Syntax to user USERPRINCIPAL name function in M

Has anyone used this function to filter a table in Power Query? I thought it would be as simple as this:

But, I'm getting an expression error I can't resolve.

 

As usual, thanx in advance for your help.

Need Help

6 Replies

  • blopez11's avatar
    blopez11
    Super User
    5 years ago

    USERPRINCIPALNAME is a DAX function

    You cannot use it in the query editor

    • pawlowski6132's avatar
      pawlowski6132
      Helper V
      5 years ago

      Crap. Of course. Duh.

       

      I don't suppose there's any way to create a Power Query LIST from a filtered DAX table either. 

       

      Frustrating.

  • pawlowski6132's avatar
    pawlowski6132
    Helper V
    5 years ago

    I think what I really want is to use the Dynamic M query parameter feature currently in preview but, not available for Oracle (or other popular data sources).

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi pawlowski6132 ,

     

    You can only use query parameter for it now. And you can change the parameter in mange parameter in Power BI desktop:

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

  • pawlowski6132's avatar
    pawlowski6132
    Helper V
    5 years ago

    Dedmon Dai, I'm don't think that's accurate. I'm sure the Dynamic M Query Paramater is also available now.