Forum Discussion

elkjoperik's avatar
elkjoperik
Icon for Helper II rankHelper II
10 years ago
Solved

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 da...
Need Help
  • elkjoperik's avatar
    elkjoperik
    10 years ago

    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's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

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's avatar
elkjoperik
Icon for Helper II rankHelper II
10 years ago

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?