Forum Discussion

DineshDwilco's avatar
DineshDwilco
Frequent Visitor
4 years ago
Solved

Split method in USERNAME() - Directquery

Hi all,

    in my mvc c# application i will pass USERNAME() as "Username | ID" in DirectQuery. How will split i need to set both condition in my Power BI Dashboard, 

    is this possible ?

 

Regards

Dinesh D

General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi DineshDwilco ,

     

    Yes, you are right. SEARCH/FIND and LEFT/RIGHT/MID are not supported with DirectQuery, but only when you want to create column. It still works in measure.

     

    Another way to split ID is edit data in power query editor, but the only ID in your case.

    If length of your ID is fixed, please try to use add a new column via 

     

    Text.End([username&ID],3) // The 3 is the length of ID

     

    But if the type of the username&ID is char this won't work.

    Then go to the power bi report page, use measure like above to get the username.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

     

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    DineshDwilco Use PATHITEM in a measure? Alternatives would be using LEFT and RIGHT in coordination with SEARCH/FIND. Not exactly sure of the scenario.