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 logs in and view the dashaboards, its not refreshing. As per the documentation, dashboard should refresh automatically but its not happening. My intenation here is to list the data that is accessible to logged in user so implemented the RLS at ssas side. 

 

I am not sure whats wrong here, let me know if someone implemented such dashboards.

 

thanks,

Madan.   

General Comment

8 Replies

  • 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...