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 ..
Anonymous
You might need to deploy and overwrite the report instead of refresh on Report Server. My test:
1. Create table column with value 1, deploy or save report to Report Server
2. Deleted all records in the source table, enter value 5
3. Save and overwrite the report on Report Server.
4. Download and export shows value 5.
Paul