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
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
      8 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

      • gustavothron's avatar
        gustavothron
        New Member
        8 years ago

        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