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
Hey v-achippa, how would one remove empty columns from the semantic model? It looks like the excel sheet which is the source for this model changed, and refreshing from desktop doesn't seem to reflect the latest version of the data
Community SupportHi 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