I have one Azure Managed stance database which has multiple tenant stored in it. Now one of my customer is asking for data source to run report using power BI. I am looking for best approach how do i share database with him as i have all the customers(tenant) in single database.
Is there way i can share database with him but will be only able to access his information from azure database?.
Create a Power BI dataset that is filtered to only that tenant and share that. If each tenant has a separate Power BI dataset there’s no need to implement row level security.