Forum Discussion

nick8181's avatar
nick8181
Frequent Visitor
6 years ago

Dynamically deploy changes from one master report to several client reports

Hi everyone,   There is a challenge I would need your help with.   So far our process of creating new reports for differrenct clients has been to create one master pbix for client A, pointing to ...
Need Help
artemus's avatar
artemus
Microsoft Employee
6 years ago

Sounds like you just need to provide PBIT files instead of PBIX files (just choose template when you do a save-as). PBIT files do not contain any of the data in the report, just the visuals, and power query code. When a PBIT file is opened, the user is presented with a dialog box to fill in any parameters that are in the report.

  • nick8181's avatar
    nick8181
    Frequent Visitor
    6 years ago

    Thank you all for your suggestions!

     

    We did consider the template and parameters option but we would like to have a process in place that minimizes manual work as much as possible.

     

    Would it be possible to have a script using M, let's say in an Excel file that would contain the DB, schema, and table information for each client, and running the script outside of the PBIT or PBIX file model would automatically change the parameters in the model?

     

    Thank you,

    Nick