Forum Discussion
Cannot Overwrite Existing Report
Hi SamPowerBIUser,
To remove empty columns and ensuring that the latest version of the data is reflected in power bi, follow below steps:
- We can remove the empty columns in the power bi desktop, open Power BI Desktop and go to Transform Data, identify the empty columns and manually remove empty columns using the Remove Columns option.
- Clear credentials by File > Options and Settings > Data Source Settings, and also clear the cache. Refresh the data after clearing the cache to ensure the latest version of the excel file is loaded.
- Check if the excel file on share point is correctly updated, if changes are not reflecting in power bi desktop, remove and re-add the data source.
- Rename the report before republishing it to avoid overwrite conflicts.
By following these steps, you can effectively clean up the data and ensure the latest data is reflected properly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi SamPowerBIUser,
Thank you for reaching out to Microsoft Fabric Community.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance?
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Anjan Kumar Chippa
Hi Anjan, thank you so much for taking the time to put this together. I think you correctly guessed that empty columns could be related to the issue, and will let you know soon!
Thanks again, and best regards
Hi SamPowerBIUser,
We wanted to kindly follow up to check if the issue has been resolved
If my response addressed, please mark it as Accept as solution to help the other members of the community find it more quickly. Don't forget to give a "Kudos" – I’d truly appreciate it!Regards,
Anjan Kumar Chippa