Forum Discussion
Issues with refresh data with an excel file (Power BI Desktop)
Hi,
So I've made a report in Power BI where the Source is a excel file.
I've tried to set the source to Onedrive Business, local (c:\) but with no success. When i make the report, the refresh data works completely fine, but the day after I load the file and click refresh, an error occours and the file is not updated with the new data;
I sent the a frown, and got the message that it's a documentet error and will be fixed in a future release. However, I need to update this report, so I just cant wait until "forever". Any smart solutions to this issue?
Regards Erik
After trying a lot of things I found the error:
A coulm which was marked as date cause the error. When i changed the coulm to whole number, the data refresh went OK. So one strange bug with Power BI
3 Replies
What is the format of your Excel Doc? is it XLSX or something earlier? If it is a document error, then maybe changing the document format will help. I have had some problems with file formats in the past and the problems have been fixed in time. But the quick solution for me was to change the file format.
Hi!
I've tested out:
- XLSM (the format I setup the report with in the first place).
- XLSX
- XLSX
I'm using Excel 2013.
Which format did you change to, Matt?
After trying a lot of things I found the error:
A coulm which was marked as date cause the error. When i changed the coulm to whole number, the data refresh went OK. So one strange bug with Power BI
