Issues with refresh data with an excel file (Power BI Desktop)

[elkjoperik]

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

[elkjoperik · Accepted solution]

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

[MattAllington]

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.

[elkjoperik]

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?