Forum Discussion

ribisht's avatar
ribisht
Helper I
1 year ago
Solved

Table Level Security

  I need assistance with one of the use cases. I have a tabular visual comprising 30 columns sourced from three different tables: a, b, and c. I created a role for a user who does not have access to...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    HI ribisht,Thanks for the clarification!  


    Giving users direct access to the Google Sheet would defeat the purpose of security. In Power BI, if a user cannot access the data source, the visual fails because the dataset cannot be loaded.

    Connect the Google Sheet to Power BI using a service account that has access to the sheet, so the data loads centrally and not based on individual user permissions. Then apply Row-Level Security (RLS) and use conditional DAX measures to show blank values for columns from Table B for users without access. This way, users will see the full visual with restricted data showing as blank, without exposing the actual Google Sheet or its contents.

     

    Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.

     

    Thank you.