Forum Discussion

gustavothron's avatar
gustavothron
New Member
8 years ago

Cannot connect Quickbooks on Power BI

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 T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
gustavothron
New Member
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      gustavothron
      New Member
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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