Forum Discussion
Exporting a report with latest data with powershell
As I know, this way is not possible. Because after upload pbix to server, is saved to DB as CatalogItem, and splited to DataModel and ReportDefinition. For Reporting is used only DataModel (whis is loaded to SSAS) and ReportDefinition for client layout.
When refreshing data, only DataModel is updated.
CatalogItem never to be updated on server side, and therefore, when you downloading pbix back from server, is still same as you uploaded.
To meet your requirements I do not know tested solution, but probably there are more ways (but no any simple). E.g. two options in my think
-you can rebuild model to dedicated model in SSAS (which bring additional benefits as incremental update), but you can replicate SSAS DB to another site (there more way how replicate), but transfered will be only compressed model.
-or can replicate SQL DB with ReportServerDB to secondary replica in another site, only compressed model will be transfered
-and additional one, but barbarian, you can try move only selected rows from CatalogItemExtendedContent table using SSIS, but I never tested it ..
As I know, this way is not possible. Because after upload pbix to server, is saved to DB as CatalogItem, and splited to DataModel and ReportDefinition. For Reporting is used only DataModel (whis is loaded to SSAS) and ReportDefinition for client layout.
When refreshing data, only DataModel is updated.
CatalogItem never to be updated on server side, and therefore, when you downloading pbix back from server, is still same as you uploaded.
To meet your requirements I do not know tested solution, but probably there are more ways (but no any simple). E.g. two options in my think
-you can rebuild model to dedicated model in SSAS (which bring additional benefits as incremental update), but you can replicate SSAS DB to another site (there more way how replicate), but transfered will be only compressed model.
-or can replicate SQL DB with ReportServerDB to secondary replica in another site, only compressed model will be transfered
-and additional one, but barbarian, you can try move only selected rows from CatalogItemExtendedContent table using SSIS, but I never tested it ..
Thank you Josef, that's the best answer so far.