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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    madan Are you using the "Live Connection" or did you import from the SSAS instance? Your description leads me to believe that either you imported, which would break the RLS. Or, it is a live connection, but something is wrong with the DAX function which should be utilizing the "USERNAME" to identify incoming requests...

    • madan's avatar
      madan
      Frequent Visitor
      9 years ago

      Anonymous im using live connection and have MDX code in my cube that defines the RLS, I didnt use the DAX function USERNAME(). Is it necessary to refer USERNAME() for RLS? we use the same SSAS cube with Performance point, SSRS and sure not if DAX functoin USERNAME() from these apps.

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        Hi madan,

         

        As any changes in the data after processing the model would be immediately available for the users who are accessing the report is based on live connection from the Power BI service, and tiles on dashboard refresh updates every 15 minutes, I don't think it is a refresh issue in this case. 

         

        So could you follow this official article to recheck the steps to implement row level security within your Analysis Services? :smileyhappy: 

         

        Regards