Forum Discussion

IvanGennaro's avatar
IvanGennaro
Regular Visitor
1 year ago
Solved

Issues with Power BI CI/CD using PBIP format, Direct Lake, Git Integration, and Deployment Pipelines

Hello community, My team and I are currently defining our CI/CD strategy for Power BI objects within Microsoft Fabric. Here’s a quick overview of what we're trying to achieve: Workflow Report Dev...
  • v-sathmakuri's avatar
    1 year ago

    Hi IvanGennaro ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    I recommend the following approach for implementing a reliable CI/CD flow for PBIP reports in Microsoft Fabric: 

     

    Place your Direct Lake model in a shared workspace. Reference that shared model from all report workspaces (Sandbox, Dev, Prod). This avoids broken bindings when the model doesn’t exist in downstream workspaces.


    Maintain Git branches like main, dev, and prod.
    Each Fabric workspace syncs to its respective branch (e.g., Dev WS <-> dev branch).
    Use Git pull requests (PRs) to promote code and control approvals.


    Use Git as the source for reports. sync from Git in every workspace. Deployment Pipelines can be used for model promotion or basic staging

     

    PBIP reports should include a connections.json referencing the datasetId and workspaceId (GUIDs), not just names.
    This ensures the report knows where to find the dataset, regardless of workspace context.

     

    You can refer to the following Microsoft documentation for more details:

     

    https://learn.microsoft.com/en-us/fabric/cicd/git-integration/manage-branches?tabs=azure-devops 

    https://learn.microsoft.com/en-us/fabric/cicd/best-practices-cicd 

    https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-git 

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!