Forum Discussion

DiKi-I's avatar
DiKi-I
Post Partisan
1 year ago
Solved

Need help

Hi ,

Need help on some questions which came from one of the client. They want to create different customer profiles in fabric but they don't want to manually move workbooks across workspaces for different customers.  Also they would like to replicate workspace , pbi for each customer. So the question is how this could be implemented in fabric in an effective way?

    • Treat each customer as a separate Fabric workspace, this isolates data, access controls, notebooks, and reports cleanly.

    • Use service principals or managed identities to automate workspace creation and artifact deployment.

    • To avoid manually moving artifacts, use Fabric REST APIs. You can script this using Azure DevOps pipelines, PowerShell, or Fabric Notebook automation (via REST API calls).

    • Use Power BI API to clone and bind datasets to different data sources (parameterized binding).

5 Replies

    • Treat each customer as a separate Fabric workspace, this isolates data, access controls, notebooks, and reports cleanly.

    • Use service principals or managed identities to automate workspace creation and artifact deployment.

    • To avoid manually moving artifacts, use Fabric REST APIs. You can script this using Azure DevOps pipelines, PowerShell, or Fabric Notebook automation (via REST API calls).

    • Use Power BI API to clone and bind datasets to different data sources (parameterized binding).
  • Hi DiKi-I ,

     

    To implement customer-specific profiles in Microsoft Fabric without manual workbook movement:

    • Create a separate Fabric workspace for each customer to isolate data and access.
    • Automate workspace and artifact deployment using service principals or managed identities.
    • Use Fabric REST APIs with tools like Azure DevOps, PowerShell, or Fabric Notebooks to script artifact deployment.
    • Use the Power BI API to clone reports and bind them to different data sources using parameterized binding.
  • v-prasare's avatar
    v-prasare
    Community Support

    Hi DiKi-I,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Community Support

    Hi @DiKi-I,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Community Support

    Hi @DiKi-I,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query