Forum Discussion
Cannot connect Quickbooks on Power BI
gustavothron,
Please check if you can connect to Quickbooks online PBIT file in Power BI Desktop. If you still get same error, please check if Quickbooks Online had any old dates before 1995 (e.g, 02/04/1984), delete these date entries in Ouickbook online, you should be able to connect to the PBIT file in Power BI Desktop.
After connecting to the PBIT file in Power BI Desktop, you can publish the PBIX file to Power BI Service.
Regards,
Lydia
Hi Lydia (@v-yuezhe-msft),
I've downloaded the file and opened in Power Bi desktop, after authenticating in intuit quickbooks's system it still presented the following errors:
https://ibb.co/c72DUe (Print Screen)
"The loading was cancelled due to an error loading a previous table"
It loads the structure of the tables and all the relationships between them, but all tables are empty, no data was loaded.
Also, there are no dates before 1995 on my quickbooks account, all dates begin in 2018.
Best regards,
Gustavo
gustavothron,
Except the above error message, there should be an error message indicating root cause of the failure. Please post the error message here and translate it into English.
Regards,
LydiaAs soon as I open the "QuickBooks Online.pbit" file, Power BI shows me the screen on the previous message:
https://ibb.co/c72DUe (Print Screen)
"The loading was cancelled due to an error loading a previous table"
No other message popup with the root cause is shown.
I am also doing some testing with the Klipfolio dashboard tool and I could access my QB data using their connector, so I think the problem is not in Quickbooks.
Best regards,
Gustavo
gustavothron,
Please go to Query Editor of your PBIX file, click Refresh Preview->Refresh all, the click the tables that throws error, you should be able to see detailed error message.
Regards,
Lydia