Table Level Security

Create a copy of the report page and remove the columns from table b.

Sorry, did not get you

Please refer https://community.fabric.microsoft.com/t5/Desktop/Column-Level-Security-with-Power-BI/m-p/4637270#M1387336 

We don't want to remove the column there instead, it should show blank for the users who do not have access to the table

Hi ribisht ,

In Power BI, when you apply Table-Level Security (TLS) and restrict access to a table (e.g., Table B), any visual referencing that table will not display for users without access—this is standard behavior, as Power BI blocks access at the object level. To address the requirement of displaying the full visual with columns from Table B appearing as blank/null for restricted users, you can implement a custom solution using a user access table and conditional DAX measures:
To resolve the issue we need to create a UserAccess table mapping each user to a flag indicating whether they have access to Table B. For each column from Table B in the visual, create a DAX measure that conditionally returns the value only if the user has access, like this:
TableB_Column1_Display =
IF (
LOOKUPVALUE(UserAccess[HasAccessToTableB], UserAccess[UserPrincipalName], USERPRINCIPALNAME()) = TRUE,
SELECTEDVALUE(TableB[Column1]),
BLANK()
)

Replace the Table B columns in your visual with these DAX measures. Finally, apply Row-Level Security (RLS) on the UserAccess table to filter data based on the logged-in user:
UserAccess[UserPrincipalName] = USERPRINCIPALNAME()

This ensures that users without access to Table B see blank values, while those with access can view the data.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you for using Microsoft Fabric Community Forum.

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.