Split method in USERNAME() - Directquery

[DineshDwilco]

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

[Greg_Deckler]

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

[DineshDwilco]

PATHITEM does not supports in DirectQuery. so i will find suitable 

[Greg_Deckler]

@DineshDwilco OK, then you will need to use SEARCH/FIND and LEFT/RIGHT/MID

[DineshDwilco]

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

[v-chenwuz-msft · Accepted solution]

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.