Forum Discussion
Helper IPBIP and RDL folder structures
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.
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!
Community SupportHello 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.
Helper Ithank you! this is what i was looking for: "If two reports share the same dataset, they can be part of the same PBIP project. Otherwise, separate them."
We've started a source control folder structure like this for our "Finance" workspace. Hopefully it will workout with CI/CD and the git integration we want to do eventually:
\Finance\RDLs
\Report1
\Report2
\PowerBI
\PBIPReport1
\ReportComponent1
\ReportComponent2
\PBIPReport2
\Sales\etc.etc.
The only thing that's kind of odd is that the report components aren't natively grouped into 1 folder. We'll have to create a folder to keep report components together.
- v-karpurapud
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!