Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DataFormat.Error: We reached the end of the buffer error from Power BI + Source Data from Azure Blob

I am using Power Source as Azure Blob Storage folder. While connecting the JSON file from Azure Blob Storage facing an error "DataFormat.Error: We reached the end of the buffer".

Need Help
Show and Tell
Tips and Tricks

5 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi,

     

    Can you check whether JSON file has any data? Usually, we get this error when you trying to import a blank JSON file.

     

    Regards,

    Venkata Nalla

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Venkata Nalla, 

       

      It gives 0 Bytes for the JSON file which I used. But in AZURE BLOB it shows 27 MB. Where the data is missing in my case. 

       

      Regards,

      Muthukumar

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous , 

     

    You may try to upgrade the Power BI Desktop to the latest version 2.82.5858.961 , and maybe the 64-bit Desktop will overcome this issue.

     

    Reference:

     

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

     

    https://community.powerbi.com/t5/Desktop/Error-oledb-or-odbc-error-data-format-We-reached-the-end-of-the/td-p/514604

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Amy,

       

      Thanks for sharing your solution. 

       

      However, I tried below steps before rasing this issue. 

       

      - Yes, I installed latest desktop version (Jun-2020), but still no luck. 

      - Also used Table.Buffer in M-Code, but still no luck. 

       

      Regards, 

      Muthu

      • v-xicai's avatar
        v-xicai
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

         

        Best Regards,

        Amy 

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.