Forum Discussion
Publish to Replace Report Does Not Overwrite Existing Report
- 4 years ago
Thanks for link for raising a ticket. I did so and this was identified as a bug in my service environment and scheduled for update to resolve.
I decided to go through Options and I may have hit on a solution. In Options -> Global -> Preview Features I checked 'DirectQuery for PBI datasets and AS' and that does an irreversible change from Live Connection to DirectQuery and allows you to have a local model. I created a local model (Transform Data) and added a blank query. When I published that it overwrite my old report. I made a second change and published it, and that also overwrote the first, so it seems repeatable. Aside from this publish issue not working with Live Connection I am not sure whether Live Connection or DirectQuery is best connection choice for my report so I'd still like to know how to do it with a Live Connection to PBI dataset if anyone has ideas.