Forum Discussion
Deploying the Data in Pipelines - new calculated column not recalculated
- 4 years ago
I think this procedure should work:
- Make a copy of current dataset in production
- Update your production report to point to dataset copy*
- Perform a selective deployment to just push the dataset only from test to production (it will overwrite your original dataset, but not the test your report is currently using)
- Refresh the newly deployed dataset (should populate your calculated column here)
- Perform another selective deployment to now overwrite the report (I believe it will switch back to pointing to the original dataset at this point, no need to do as a separate action beforehand)
- Delete the dataset copy from step #2, since it's no longer needed or in use
*If you haven't already, you can split your pbix into two files: one where you just define the model (can leave report page blank or use for testing, and then just delete the report, exclude from app, etc.), and the other where you specify a Live connection to the dataset of the first and build out your report. This way, your report and dataset are managed by separate pbix / deployable content.
I think this procedure should work:
- Make a copy of current dataset in production
- Update your production report to point to dataset copy*
- Perform a selective deployment to just push the dataset only from test to production (it will overwrite your original dataset, but not the test your report is currently using)
- Refresh the newly deployed dataset (should populate your calculated column here)
- Perform another selective deployment to now overwrite the report (I believe it will switch back to pointing to the original dataset at this point, no need to do as a separate action beforehand)
- Delete the dataset copy from step #2, since it's no longer needed or in use
*If you haven't already, you can split your pbix into two files: one where you just define the model (can leave report page blank or use for testing, and then just delete the report, exclude from app, etc.), and the other where you specify a Live connection to the dataset of the first and build out your report. This way, your report and dataset are managed by separate pbix / deployable content.
- mshparber4 years agoAdvocate I
Yes, I think this can work.
Wish they had more options for deployment.
Thanks!