Cannot connect Quickbooks on Power BI

[gustavothron]

Hi,

I am having some trouble trying to connect Power BI to Quickbooks. I've already tried 4 times and got the following error messages. Can someone help me with this issue?

********* ERROR #1st Try *********
Não foi possível instalar QuickBooks Online
Erro durante o processamento de dados no conjunto de dados.
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
Message: The column 'Date' of the table wasn't found.
ID da atividade: 4cacdbd3-a485-433c-8f03-bfb9ab6bd09e
ID de correlação: 9a5602b1-86e1-e91d-ceb5-2ae4114285dc
Solicitar ID: 928229a1-6ccd-373a-6452-221a512b2913
Código de status: 400
Hora: Wed Aug 29 2018 16:35:14 GMT-0300 (Horário Padrão de Brasília)
Versão: 13.0.6430.141
Cluster URI: https://wabi-brazil-south-redirect.analysis.windows.net

********* ERROR #2nd Try *********
Algo não deu certo
Não foi possível carregar o relatório
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
ID da atividade: 55f2d587-75d1-9693-21d2-184fb8ad82ca
Solicitar ID: cdfb2703-582f-2c96-daee-37297189a1df
ID de correlação: f5ddb029-8df7-e5c2-3700-20d017666190
Código de status: 500
Hora: Wed Aug 29 2018 17:07:04 GMT-0300 (Horário Padrão de Brasília)
Versão: 13.0.6430.141
Cluster URI: https://wabi-brazil-south-redirect.analysis.windows.net

********* ERROR #3rd Try *********
Não foi possível instalar QuickBooks Online
Erro durante o processamento de dados no conjunto de dados.
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
MessageThe column 'Date' of the table wasn't found.
ID da atividade4cacdbd3-a485-433c-8f03-bfb9ab6bd09e
ID de correlação3e2c3bf2-c7da-6aeb-b5a7-77591468d030
Solicitar IDac8c1b97-c80a-efa1-62e0-7f3c62a0a08f
Código de status400
HoraWed Aug 29 2018 17:18:05 GMT-0300 (Horário Padrão de Brasília)
Versão13.0.6430.141
Cluster URIhttps://wabi-brazil-south-redirect.analysis.windows.net

********* ERROR #4th Try *********
Algo não deu certo
Não foi possível carregar o relatório
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
ID da atividade4cacdbd3-a485-433c-8f03-bfb9ab6bd09e
Solicitar ID820f62cf-a7e8-a87c-7df0-18f205d1926c
ID de correlação67e88dc7-72f1-11d7-36cc-827fa689db99
Código de status400
HoraWed Aug 29 2018 17:24:11 GMT-0300 (Horário Padrão de Brasília)
Versão13.0.6430.141
Cluster URIhttps://wabi-brazil-south-redirect.analysis.windows.net

[v-yuezhe-msft]

@gustavothron,

I would recommend you create a support ticket in Power BI support site.



Regards,
Lydia

[gustavothron]

Hi Lydia,

I've already tried opening a support ticket in the first place, but the Power BI website redirected me to this forum as I am using a trial version of the Power BI tool.

I am a consultant and I help my clients testing and selecting tools to help them improving their management performance. One of my clients needed a tool to generate dashboards directly from Intuit Quickbooks (using their API) and I tought of Power BI as a good candidate, but without proper support I could not see the full potential of this tool and I think it is not fair to pay upfront for a test without knowing if the tool will serve my clients' needs.

Thanks.

Best Regards,

Gustavo

[Anonymous]

@v-yuezhe-msft Hi Lydia, tried downloading pbit file but link is no longer valid, can you please reshare the pbit file?

[v-yuezhe-msft]

@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

[gustavothron]

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

[v-yuezhe-msft]

@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,
Lydia

[gustavothron]

As 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

[v-yuezhe-msft]

@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

[gustavothron]

Hi,

Here goes the print screen showing the error:

https://ibb.co/mtAjue

Translation:

Expression.Error: The column "Date" from the Table was not found.

I get the message above from the tables DateTable and GeneralLedger.

Best regards,

Gustavo

[v-yuezhe-msft]

@gustavothron，

Please review each step in APPLIED STEPS of the Date table to check which step throws this error. And please check if there are any invaild dates in your Ouickbooks data source.

Regards,
Lydia

[gustavothron]

Hi Lydia,

Here goes another print screen:

https://ibb.co/mw9HXz

On the APPLIED STEPS ("PASSOS APLICADOS" in portuguese) section, the step Navigation ("Navegação" in portuguese) seems to be throwing the error.

Just checked again and I have no invalid dates on the tables.

Best regards,

Gustavo