Forum Discussion

Mal_Wallasey's avatar
Mal_Wallasey
Frequent Visitor
2 years ago
Solved

DataFormat.Error: We have reached the end of the buffer IDbCommand (BI Service only not Desktop)

This is the example Power Query which gets data from SysAid (IT Helpdesk System)   let Source = Table.FromColumns({Lines.FromBinary(Web.Contents("Paste the URL from POWER BI Extract addon", [Head...
Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi Mal_Wallasey 

     

    I think this can happen sometimes when the API does not complete successfully.

     

    One workaround is if you have got an On-Premise gateway you could create a data source in the Gateway and then connect to it that way and see if that works?

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

Hi Mal_Wallasey 

 

I think this can happen sometimes when the API does not complete successfully.

 

One workaround is if you have got an On-Premise gateway you could create a data source in the Gateway and then connect to it that way and see if that works?