Forum Discussion
How to run a report using service/proxy account?
There will be two seperate reports. for example,
We have two separate financial reports built from Finance model.
Report 1: Budgetary Report (Manager View) This report focuses on cost centers and shows budgetary and actual spending data. It leverages Row-Level Security (RLS) to restrict data visibility based on a manager's assigned cost centers.
Report 2: Corporate Finance Statement Report (Full View) This report provides a high-level view of financial information for the entire corporation.
Once we add manager to RLS on the cost centers in the model, the first report works perfectly but the second one will only aggregate the info in their cost centers.
Because powerbi service only suppport pass through authentication we can not use proxy account for the second one like what we do in powerbi on-premise. The only option I can think of is to duplicate the same model with/without RLS added and use them for the reports seperately, in this way, it is not just resoures wasting, maintaining them to sync will be a big challege.
- lbendlin2 years ago
Super User
You can either use a shadow summary fact table that is not controlled by RLS or go with the approach you mentioned. I think the additional maintenance effort is manageable.