Forum Discussion
File corrupted after compressing back to pbix
- 8 years ago
By do you need to unzip it? Just rename it to a zip file and access what you want without unzipping it. Then rename it back
By do you need to unzip it? Just rename it to a zip file and access what you want without unzipping it. Then rename it back
- lcesarini5 years agoFrequent Visitor
Hi, Matt
I tried this way but unfortunately it doesn't work (at least with "pea zip" and "7zip").
Any change at the end PowerBI says that the file is corrupted. Can you telle me please wich compressing application are you using?
The reason why it is necessary to access to unzipped source is that this way seems the only solution for aligning the report to a renamed dimension widely used inside report itself, connected to SSAS cube,.
As far as I know there are not tools inside BPI Desktop to make such operation on visuals, and sincerily I don't understand why such a basic development functionality has not been yet implemented. A change in dimension naming convention inside an Enterprise cannot be excluded and without any tool for a bulk renaming, it could become a nightmare.
Some functionality like the "Advanced Editor" (not available by the way on SSAS connections), but extended to whole report would be very useful.
Thank you
- melwakil8 years agoFrequent Visitor
Hello, I have a corrupted message even if we rename the file to .zip !
- timroper4 years agoNew Member
EDIT: If you want to overwrite the same report in Power BI service, you'll need to retain the Report ID int he RemoteArtifacts section of the config. If you just copy the whole lot like I suggested below you will get a new report and new dataset created which probably isn't what you want.
can confirm that if you edit the archive directly in 7zip (i.e. don't unzip make changes and then recompress) it works.
To get a known-good connection string make a dummy report connected to your new data source and copy the entire contents of the 'Connections' file. Wasn't enough for me to simple change the SSAS instance name