Can I have one same semantic model for tens of workspace where each worksapce has it's on credential

[Tom-Fabre]

Hi, I have a question, in the company I work, we have a workspace for each customer, and all the customers shares the same Power BI Report, but each one has it's on credentials to the database, we're facing a problem related to the updates of the semantic models, because when we schedule it by hand, sometimes the schedule is disabled, and we have more than 250 customers, it's complicated to check one by one to see if it's scheduled.

I've made a research that it's possible to automatically update the semantic models by using Apache Air Flow, but I don't have enough permissions to test it, so I was wondering, what if I have only one 'universal' semantic model, and the Power BI Reports were based on this semantic model. Would semantic models still change each customer's database connections dynamically?

[v-karpurapud]

Hello @Tom-Fabre 

I would like to know if the issue has been resolved. If so, kindly mark the reply that provided the solution as accepted. This will help other community members facing similar challenges to find a resolution more efficiently.

Thank you!

[v-karpurapud]

Hi @Tom-Fabre 
Hope you are doing well!

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super user helps you? or let us know if you need any further assistance here? 

Your feedback is important to us, Looking forward to your response.

Thanks You.

[v-karpurapud]

Hi @Tom-Fabre 

Thank you for reaching out Microsoft Fabric Community Forum 

We have reviewed the response provided by @SaiTejaTalasila  and @AnkitKukreja   found it to be accurate and helpful.Could you please confirm if your query have been resolved or let us know if you need any further assistance here? 

If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you

[SaiTejaTalasila]

Hi @Tom-Fabre ,

Use power automate flows to refresh your dataflows/datasets and you can notify your down stream users with success/failure.

I hope it will be helpful.

Thanks,

Sai Teja 

[AnkitKukreja · Accepted solution]

Hi! @Tom-Fabre 

Yes that's possible you can achieve dynamic connections in Power BI by leveraging parameters for database connection details. These parameters can store information like:

• Server Name
• Database Name
• User Credentials

• Go to Transform Data > Manage Parameters and create parameters for connection details (e.g., server, database, user credentials).
• Use these parameters in your data source query.

And you can publish this in different workspaces and change the parameters as per your requirements.