Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Non-negative number required error while appending tables

Hello,   I'm trying to append 2 large datasets (22M & 30M) of same table format in Power Bi using Append Queries option. But I'm recceiving the below error. Not sure what this error means. Please a...
Need Help
motoroto's avatar
motoroto
Frequent Visitor
7 years ago

Hello, we are having the same issue. Did you get to solve it?

 

B rgds,

boylec's avatar
boylec
Advocate I
7 years ago
I’m working with a pro support rep on it the last two days. He said the latest October release of PBI Desktop should have patched the bug. I’ve yet to try it. Are you using the latest Power BI Desktop?
  • UAV-Test-Pilot's avatar
    UAV-Test-Pilot
    Helper II
    7 years ago

    I am using PoweryQuery plugin for Excel 2016

     

    Anybody know how I can get this update?

     

    Excel version 16.0.4738.1000 64 Bit

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      While the Power BI team was working on this fix, I modified my query to avoid loading such a large amount of data.

       

      Recently, though, the Power BI support person I was working with followed up with me to let me know this problem has been fixed by the product team in the latest version of Power BI Desktop (December release).

       

      I went back to replicate what I was originally trying to do, and I am no longer having the problem.

      • UAV-Test-Pilot's avatar
        UAV-Test-Pilot
        Helper II
        7 years ago

        Any news if this will be pushed to PowerQuery for Excel as well?