Forum Discussion
Table Level Security
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.
Hi ribisht,
Thank you for the clarification!
The "Caller does not have permission" error is occurring because the user does not have access to the Google Sheet that serves as the data source. Without access to the source data, Power BI cannot retrieve any data, which causes the permission error.
To resolve this, please ensure that the user has the proper access to the Google Sheet itself. Once the user has access to the data source, you can implement the solution I suggested earlier, using DAX measures and Row-Level Security (RLS) to conditionally show blank values for columns from Table B for users who do not have access. This will allow the visual to display with blank values for the restricted columns while still showing the rest of the data as expected.
Please Accept as solution if this meets your needs and a Kudos would be appreciated.
Thank you.
Thanks v-sgandrathi a lot for your reply but if I give him the access to the google sheet then what will be the use of security 🙂 , he will see everything which he is not supposed to see
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.
Hi ribisht,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!