Forum Discussion
Quickbooks error - DataFormat.Error: We couldn't parse the input provided as a Date value.
Hello martin_makar,
Could you please try the following:
- 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.
- 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.
- 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.
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
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.