How to deal with multi schema in power bi?

[hungvuong1003]

Hi All,

My system has multiple databases, every databases(schema) is for every single customer. I am using power bi to design the report and I want to load the report with the corresponding database based on the customerID. I tried tons of research but could not find the solution for this. Any idea to help me out? thanks so much.

[v-jiascu-msft]

Hi @hungvuong1003,

If you want to create one report for each customer, you can try blog/deep-dive-into-query-parameters-and-power-bi-templates/.

If you want to create one report for all customers and filter the report by customer id, the solution could be creating the report with all the data and filtering it by RLS. Please refer to desktop-rls and service-admin-rls.

Best Regards,

Dale

[hungvuong1003]

Thanks v-jiascu-msft,

For option 1: Can we do that by script? I want to do that dynamically when a new customer comes into my system.

For option 2, the difficulty is my data is huge and if a new user come into the system, we need to mannually import the new schema to power bi and using combine query to combine new table into the mutual table. Is there any way to do that dynamically?

[v-jiascu-msft]

Hi @hungvuong1003,

For option 1, do all the customers have the same structure data? If so, you can define some parameter in the template. You can open the template and enter the parameters when the new customer comes. 

What kind of script do you mean?

For option 2, I'm afraid there isn't a way to do that. If all the data are in one source, we can refresh the report to get new data. But the sources are created after the creation of the report. 

Best Regards,
Dale