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 ..
For the record, I also tried with the REST API using: /PowerBIReports({Id})/Content/$value
I get the same behavior, this is not a surprise since I believe the powershell methods uses the API behind the scene. I'm looking through the API documentation but so far nothing looks helpful for my needs.