Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

how Can we pass USERPRINCIPLE or USERNAME as a query parameter in Power Query

Dear experts: Now I'm facing a difficulty on data protection: there is a tableA in sql server database, our team has 3 powerbi desktop developers, each developer should only get restriced rows in ta...
Data Protection
Need Help
  • Gabry's avatar
    Gabry
    2 years ago

    I understand your needs but I think it's not possible. I can't figure out other solutions.

     

    The only thing I can still suggest is to duplicate the semantic model, or make a specific dataflow for each developer, then each developer will connect to his own dataflow

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI, Gabry:

thanks for your reply. Create views in source database is a good solution, but the semantic model has 7-8 tables, and developers can be divided into 5 access group, so we have to create too many views.

We realy hope that power bi can pay attention to row level control for power bi desktop developers, so that developers(builder role) can have a way to get same access limitation as viewer role.

Gabry's avatar
Gabry
Super User
2 years ago

I understand your needs but I think it's not possible. I can't figure out other solutions.

 

The only thing I can still suggest is to duplicate the semantic model, or make a specific dataflow for each developer, then each developer will connect to his own dataflow