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,

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