Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Hello @martin_makar,
Could you please try the following:
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.
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |