Posted 7 February 2021, 6:28 pm ESTHi,
We are facing a new problem when saving some file with pivot table connected to analysis service data source. Please refer attachment for reproduction.
[AdHocReport_test.xlsx] can be opened by excel with no problem with a dialog prompted to connect to the data source.
[AdHocReport_test_saved.xlsx] is the file saved using the API. It is corrupted when opened in Excel.
We expected the behavior should be the same after saving without file corruption.
Please help to investigate this issue. Thanks.