Forum Discussion

madan's avatar
madan
Frequent Visitor
9 years ago

Power BI Dashboard refresh issue.

Hi,   I have build a power BI dashboards on top of on-premise ssas datasource and the RLS is implemented at SSAS and i shared this dashboards with other members of my organization. When a member lo...
General Comment
Anonymous's avatar
Anonymous
Not applicable
9 years ago

madan Are you saying that the data in the model is different from what the user should be seeing (this statement taking into account that they should only see a limited dataset)?

The "live" connection doesn't meant that the model will refresh everytime, it only shows what is in the existing model. You would need to schedule a seperate process to re-populate the model with the latest data set.

 

The dashboards themselves refresh on a seperate cadence of 15 minutes.

madan's avatar
madan
Frequent Visitor
9 years ago

Hi Anonymous,

 

Thanks for your time. I am trying to achieve the data security here, i mean the user with whom dashboard is shared should be able to see only the data that he/she is permitted to view. Ex, my dashboard lists data for Dept1, Dept2, Dept3 & Dept4, i have setup security at SSAS in sucha way that

1) User1 is permitted to view only Dept1 & Dept2

2) User2 is permitted to View only Dep3 & Dept4

3) User3 is permitted to view Dept1,Dept2, Dept3 & Dept4

 

User3 build the dashboard, published on to BI service and shared it with User1 & User2. When User1 & User2 access the dashboard its showing all Depts but it should show only dept that they are permitted to view.

 

I am not sure how the Schedule refresh help in this scenario? Let me know your thoughts.

 

Thanks,