Forum Discussion

julsh41's avatar
julsh41
Icon for Helper II rankHelper II
7 years ago

Quickbooks Online Time Activity Table

 

I have connected my company's Quickbooks Online Account to PBI Desktop, and I have 99% of hte information I need.  The ony thing I am missing is for the Time Activity table, it does not include the employee name that the timeactivity data being shown. That is literally the last piece of the puzzle for me but it is a big one.  Does anyone know how to add it?  I don't see a way to get it through relationships based on the columns they give you in the table.

 

OR does someone know a URL Fragment for the fx REport function that could pull all Time Detail by Employee?

 

Thanks

 

Need Help

12 Replies

    • julsh41's avatar
      julsh41
      Icon for Helper II rankHelper II
      7 years ago

      Yes I have everything turned on from the Quickbooks side already

    • julsh41's avatar
      julsh41
      Icon for Helper II rankHelper II
      7 years ago

      Hi Maggie ,

       

      Any other possible solutions to my issue.  If I had the employee column to this piece of the report then I would have everything I need.  Is there another way to access it if the QBO bridge is not going to work?

       

       

      Best Regards,

       

      James

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi 

        Do you have Time Activity Table on Quickbooks Online?

        if there is no such table in Quickbooks side, it also shows no Time Activity Table when connect it to power bi.

        power bi can't fetch content that the data source doesn't contain.

         

        Best Regards

        Maggie

  • andywondra's avatar
    andywondra
    New Member
    7 years ago
    Did you ever figure this out? I have the same issue plus a few more. I regularly use the Quickbooks online report "Time Activities By Customer Detail" which gives me Date / Employee / Memo Description / Duration for each Customer. I track total time, not start and end times. I then extract that info to Excel for further analysis (average hourly rates and other calculations.) I am unable to get any of this via the table "TimeActivity" when viewing in Power BI Desktop version. Like you said, I am also unable to connect other tables via relationships since the unique identifier "Id" doesn't bring over the correct content. Any help is greatly appreciated! I hope you've had some luck the last month or so! Let me know. Thank you.