Forum Discussion

Mansi_C's avatar
Mansi_C
New Member
3 years ago

Help Required to read semi Col. separted values

Hi All, 

I am working as Tech Lead for one of the Projects where we are using tableau data as our source. Basically the data is stored with Row level security Implemented already on the aggregates and we need to read that data as source on PBI. 

I am not familiar with PBI but on tableau we have written a logic to read the semi col value in a col. without splittng the col to rows as below :

 

if

CONTAINS (LOWER(TRIM( if not ISNULL([Supervisor Id])
then [Supervisor Id (copy)] end)),LOWER(TRIM(USERNAME())+';')) THEN TRUE

 

Sales_AmountInvoice_Amount_LOCInvoice_Amount_Tar_CurGross_Sales_Tar_CurFiscal_Week_numberFiscal_Day_in_QTRFiscal_Week_in_MonthFiscal_Year_Work_Day_NumSALES_AMOUNT_CYSALES_AMOUNT_LYGross_SALES_AMOUNT_CYGross_SALES_AMOUNT_LYSales_Rep_IDLevel_1_Manager_IDLevel_2_Manager_IDLevel_3_Manager_IDLevel_4_Manager_IDSUPERUSER
3364.3738763876387612563242 3364.37 3876thompm34brownl2ellist4bonep1webbm7boses8;raupas2;arorav4;lotlib2;cunnit8;yuanm5;rj8;Sharma75;smitha96;afzala3;madaaa2;smithp38;nicola4;kollic2;bennej10;endalp2;leongc1;carnae2;neohy2;sivana3;ongg2;pienkd2;sg6;kaintn2;bhatr7;cuil9;bartol9;kanagr1;warris3;gopals11;menjij2;neohy2;salmos2w;allb1;whiter13;seider2;marinm2;mackj1;brewej4;weidmj1;njokun1;moelld1;goodhn1;paulj3;racanv2;anderd51;volzd1;thomar25;napolg1;chanf2;mandav1;mactaa1;perrym8;rosenm16;ongl5;gallaj21;trinha2;sarruj1;saxenh2;limk11;ongs3;mohams7;linl3;gamblk3;suriss2;dinhn3;devulg1;fryerj1;singhv10;chaudm2;yuvark2;rs7;beatha2;helmss1;gallaj2;trinha2;carnae2;wankm2;halld24;brownk26;malcol2;moharb2;subudc2;swatik3;beherb3;jainc2;nijjas2;lime6;cna1;ngoj5;silvar43;singhr34;atalli1;chandp12;neohy2;krishs21;rc2;vijayp7;meadr2;mouraj2;howarb6;bhutav1;bowenj8;dalyf1;goodws1;hurlej6;kerrum1;jonesm44;hallk3;kumarr81;pantm2;jelact2;glyzaa2;lumina2;gaykes2;ongf1;mandab5;enagas2;shafis2;areevn2;fengm5;tsana2;Swayas2;chanc30;smiths83;millea51;kuhns1;vasquc14;ranap5;vanitj2;pannev2;devlib2;sharmm42;ss57;desmup2;miglan2;somavn2;thanut1;ongarm1;

 

Is there a way to do the same thing on PBI? Spliting will not help us as It will result in bloating of sales numbers. 

Request all the help that I can get on this , we have been stuck for last 3 weeks to identify the right solution

 

Thanks

Mansi 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Mansi_C ,

     

    Could you make a sample table to illustrate the rules you want to implement in RLS in Power BI? Which roles can filter out which rows? This would be very helpful. Thanks!
    Power BI Row Level Security RLS Setup

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data