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 ?   Rega...
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.

     

     

DineshDwilco's avatar
DineshDwilco
Frequent Visitor
4 years ago

I checked with MS Document  SEARCH/FIND and LEFT/RIGHT/MID are not supported with DirectQuery.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
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.