Forum Discussion

mferraricloudsu's avatar
mferraricloudsu
Regular Visitor
3 years ago
Solved

Dynamic SQL datasource selector

We have this scenario: 1 Azure App Service back-end API service (.NET 7) 1 Azure App Service front-end client App Azure SQL Server elastic pool with hundreds of databases   Basically, a user l...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI mferraricloudsu,

    It sounds like indireclty getting data requirement. You can store these company and correspond server information to a table and use power bi to getting data form that table.
    Then you can simply use M query to getting data from specific row of the table records. (use these field values as connection strings to getting data)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI mferraricloudsu,

I'd like to suggest you binding users with their companies and use company field to link to other fields. Then you can add a RLS filter on the company field based on current username to apply to users.

After above steps and assign role to users, these records will be fileted based on current users’ company.

Solved: RLS with UserName() - Microsoft Fabric Community

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Regards,

Xiaoxin Sheng