Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DataFormat.Error: We reached the end of the buffer.

Hi,   So I am puzzled by this problem, and I am now at my wits' end.   I have a PBI Desktop report with tables from an on-prem SQL Server and an Azure SQL database using import. I tried to add tw...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

     

    So, apparently just waiting and trying again the day after solved the problem. A bit frustrating since I used a couple of hours trying to troubleshoot. 

     

    Anyways, now it's working!

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Which version of Desktop did you use? The 32-bit or 64-bit? I think this issue could be temporary. Maybe we can use the 64-bit Desktop to overcome this issue. Some references are as follows. 

1. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2016/power-query-getting-dataformaterror-message-when/fe1fce88-2247-4522-a7d3-d387635a8882

2. https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-reached-the-end-of-the-buffer/td-p/296097

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

So, apparently just waiting and trying again the day after solved the problem. A bit frustrating since I used a couple of hours trying to troubleshoot. 

 

Anyways, now it's working!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I'm not 100% sure but it seems in my case R script parsing empty (not null) text cells into a new column produced this error as well.