Combine data before importing to Power BI

Hi PC20 ,

Based on your description, it seems that you are trying to combine data from different data sources (SharePoint and Azure Data Lake (ADLS)) based on the username field. But the problem is that username is sensitive info and you don't have permission to see it. So you want the data from both sources to be combined before importing to Power BI, and the username to be masked. If this is the case, I'm afraid you'd have to start with mask username field information on the data source side separately. Then connect to both data sources in Power B. But I'm afraid the tables can't successfully match the right information due to the masked username each other.

Data Masking in Power BI Strategy for Testers and Users

Also, if you just report consumer can't see the actual username and use masked username instead, you can refer to the following blog to implement it.

Masking confidential data in Power BI reports - DataChant

let
    Source = (txt, convTable) =>
let
    FnConvertCharacter = (c, convTable) =>
        let
            num = Character.ToNumber(c),
            mod_num = Number.Mod(num, 2048),                
            converted_num = try Table.Column(convTable, Text.From(mod_num)){0} otherwise num,
            converted_char = Character.FromNumber(converted_num)
        in
            converted_char,

    ObfuscatedList = List.Transform(Text.ToList(txt), each try FnConvertCharacter(_, convTable) otherwise _),
    res = Text.Combine(List.Transform(ObfuscatedList, Text.From))
in
    res
in
    Source

Best Regards