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

    • madan's avatar
      madan
      Frequent Visitor
      9 years ago

      Hi v-ljerr-msft

       

      Thanks for you time. I saw the post that you tagged in your reply, it refers DAX function USERNAME() while definig RLS in SSAS. I have MDX code that defines RLS and is working fine when i refer my SSAS from perfomance point and other applications. my question is, is it a must to refer USERNAME() while defining RLS in SSAS for PowerBI dashboard to filter the data based on logged in user role?

      • madan's avatar
        madan
        Frequent Visitor
        9 years ago

        i am connecting to SSAS MD with live connection, power bi dashboard is displaying the data but is not applying the RLS. I have changed my SSAS cube RLS to refer USERNAME() but still the same issue.

        I see in some posts that Power BI should work fine with the SSAS MD security model defined at dimension level and i have setup my security in my cube at dimension level only.

        Anyone had similar issue? Does Power BI filters data only on SSAS Tabular model?