Forum Discussion

DSQU's avatar
DSQU
Icon for Helper I rankHelper I
1 year ago
Solved

PBIP and RDL folder structures

We have 1000 RDLs on a SSRS 2016 server we're migrating to the Power BI Service, broken up into ~50 or so departments/folders on th server.    As examples, the structure is something like a "Financ...
  • v-karpurapud's avatar
    1 year ago

    Hello DSQU 


    Thank you for your question. I understand the challenge of migrating your 1000 RDLs from SSRS and integrating them with new Power BI reports while maintaining a structured organization.

     

    A PBIP is linked to a specific Power BI report (.pbix) and cannot exist independently; creating a PBIP for "Finance" will designate "Finance" as the report name, generating a Finance.Report folder, as PBIP is designed to group files related to a single report rather than all reports for a department.

     

    If two reports share the same dataset, they can be part of the same PBIP project. Otherwise, separate them.

     

    In Power BI Service, there are no folders like in SSRS. SSRS RDL reports should be uploaded as Paginated Reports into the Finance workspace without using PBIP, by publishing them via Power BI Report Builder.

     

    In the meantime, please ensure that new Power BI reports are organized separately, clearly distinguishing them from previous paginated reports and latest Power BI reports.

     


    If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

     

    Thank you.

  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hello DSQU 

    Your source control structure is well-organized and should work effectively for CI/CD and Git integration. Regarding your concern about PBIP components not being grouped into a single folder, PBIP automatically structures them separately (e.g., .report, .dataset, metadata files). While this behavior cannot be changed at the project level, you can introduce an optional PBIP_Components folder within each PBIP report to logically group related files together.

    For example:

    \Finance\PowerBI

       \PBIPReport1

           \PBIP_Components

               \PBIPReport1.Report

              \PBIPReport1.Dataset

    This approach maintains PBIP’s required structure while providing a more organized view for version control.

    If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.

     

    Thank you!