How to connect multiple schemas in power bi ( if new schema added it should fetch automatically)

[ShivaPr]

Hi all , 

I have one scenario , there is a database it has 3 schemas , each schema has 40 tables with same structure . schemas are for different customers , I need to show RLS based on customer in power bi report . 

Now the question is 
1.How to connect multiple schemas 
2.In future if schema added that should get power bi when it gets refreshed . 

I know we can do parameterization for server and database , but the question is different schemas in database .

How to achieve it ? if any related tutorials , vidoes also fine or any approach is also fine 

Thanks in advance 



Regards 
ShivaPrasad

[V-yubandi-msft · Accepted solution]

Hi @ShivaPr ,

Thank you for engaging with the Microsoft Fabric Community. You're right that server or database parameterization doesn't address this issue Power BI doesn't allow for dynamic schema switching. Because RLS operates only at the row level, the standard solution is to combine tables from all schemas into one table or view, include a Customer or Schema column, and then apply RLS to that column. This setup also ensures that new schemas are automatically included during refresh if the ingestion process is dynamic.

Regards,

Yugandhar.

[V-yubandi-msft]

Hi @ShivaPr ,

We haven’t received a response from your end yet. Please let us know whether the issue has been resolved or if you’re still facing any difficulties. Feel free to reach out if you need further assistance.

Thank you.

[V-yubandi-msft]

Hi @ShivaPr ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further.

Thank you.

[krishnakanth240 · Accepted solution]

Hi @ShivaPr 

We can create a view (or ETL layer) in the database that union tables from all schemas and adds a Customer column then connecting Power BI to the single view and applying RLS using that column or handling in the database layer using metadata table to rebuild the view whenever a new schema is added and Power BI will then pick the data on the refresh.

[V-yubandi-msft · Accepted solution]

Hi @ShivaPr ,

Thank you for engaging with the Microsoft Fabric Community. You're right that server or database parameterization doesn't address this issue Power BI doesn't allow for dynamic schema switching. Because RLS operates only at the row level, the standard solution is to combine tables from all schemas into one table or view, include a Customer or Schema column, and then apply RLS to that column. This setup also ensures that new schemas are automatically included during refresh if the ingestion process is dynamic.

Regards,

Yugandhar.