Forum Discussion

martin_makar's avatar
martin_makar
Frequent Visitor
3 years ago

Quickbooks error - DataFormat.Error: We couldn't parse the input provided as a Date value.

Hi, having issues with quickbooks as a datas source on power bi desktop

 

in query editor, i'm using "= QuickBooks.Tables()" on blank query to get General Ledger table from intuit

i can connect and see the tables but get an error on 2 tables when drilling down into them

 

tables "DateTable" and "GeneralLedger"

 

the issue seems to be with the "DateTable" but both show the same error

 

ERROR:

"DataFormat.Error: We couldn't parse the input provided as a Date value.
Details: Beginning Balance"

 

i use this method for other companies with no issues

only one company is giving me this error

 

I have tried contacting Intuit but have gotten no help from them

i have also tried "Remove Error" and this removed the "DateTable" which would be fine if it worked but "GeneralLedger" table continues to give me the error

 

all other tables work as expected and i'm able to work with them

 

if anyone could guide me to a solution, i would be very thankfull

Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    3 years ago

    Hello martin_makar,

     

    Could you please try the following: 

     

    1. Check the format of the date column in the "DateTable" and "GeneralLedger" tables. Make sure that the format is consistent and matches the format of other date columns in your Power BI report.
    2. Check the date values in the "DateTable" and "GeneralLedger" tables to see if there are any invalid or missing values. If you find any such values, you can either remove them or replace them with valid date values.
    3. If you are still unable to resolve the issue, you can try importing the tables separately, rather than using the QuickBooks.Tables() function. To do this, you can click on "Get Data" and select "QuickBooks" as the data source. Then, select the table you want to import and follow the prompts to connect to your QuickBooks account.

    Let me know if you might need further assistance.

    • martin_makar's avatar
      martin_makar
      Frequent Visitor
      3 years ago

      Thank you Sahir, for the response...

      "Get Data" and Select "Quickbooks" is not an option for me because it is missing the "General Ledger" table.

       

      i have learned to use Quickbooks older api from here which contains the general ledger table

      https://community.powerbi.com/t5/Desktop/Quickbooks-Online-General-Ledger-Table-is-gone/m-p/906239#M434313

       

      I cannot drill into the table to even see the format or value of the date column on either the "General Ledger" or the "Datetable"

      the error prevents me from doing anything

       

      QUERY......

      let
      Source = QuickBooks.Tables(),
      generalledger = Source{[Key="datetable"]}[Data]
      in
      datetable

       

      RESULTING ERROR.......

      DataFormat.Error: We couldn't parse the input provided as a Date value.
      Details: Beginning Balance

       

      i know that this is an issue with formating or data value error in the table

      what is interesting is that neither the General Ledger nor the Datetable have a column called "Beginning Balance" which is mentioned in the error. the error detail just isnt very helpfull. in fact, there is no table with a column names "Beginning Balance" in the entire data source from quickbooks.