Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We are getting data refresh issues on a PowerBI report due to some empty columns in the source (Excel file hosted on SharePoint). After File > Download this file and choosing the "copy with live connection" option, I was able to refresh the data without issue. Really weird how the scheduled refresh didn't work but refreshing in Desktop gave no error...
After attempting to republish this dashboard, I'm getting a "Couldn't publish to Power BI" error message
There is no option to overwrite. After doing some research online I can't find anyone with the same issue. For context, I am not the owner of this report, but am a Workspace Admin.
Any help would be greatly appreciated, I'm quite new to PBI so it could be something obvious.
Solved! Go to Solution.
Hi @SamPowerBIUser,
To remove empty columns and ensuring that the latest version of the data is reflected in power bi, follow below steps:
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.
This issue likely arises from a combination of power bi's handling of data source connections, permissions, and publishing conflicts. Please follow below solutions:
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
Hi @SamPowerBIUser,
To remove empty columns and ensuring that the latest version of the data is reflected in power bi, follow below steps:
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
18 | |
18 | |
13 | |
12 |
User | Count |
---|---|
36 | |
22 | |
21 | |
18 | |
12 |