Forum Discussion
Helper IIQuickbooks Online Time Activity Table
Community ChampionHi andywondra,
I've found a way to get the missing data: https://www.thebiccountant.com/2019/01/10/get-full-time-activity-data-from-quickbooks-into-power-bi/ :)
- I will spend a little time on this later today, but your solution looks like it has it all! You are amazing BICCOUNTANT!!! Thank you.
julsh41Imke!!! This is perfect!!! Thank you so much. It also worked with the "Budget" information which had the same problem where I couldn't get details out. I second Andy's opinion, you are amazing!
- julsh41
Is there a way to use this functionality to extract employee cost data? I would like to be able to assign each employee a hourly cost rate based on Salary + Benefit + Taxes. Then I could "charge" a project for each persons work on a project. I thought it would be on the employee page, but it is not. Any thoughts?
- ImkeF
Yes, there is a field in the employee tab "BillableRate".
It will also not be delivered by the standard object in PBI, but you can just use:
select * from employee
in the Entity-function (like described in my blogpost) and the field will come through (called "BillRate" there)
... provided, you're not using the payroll-module (see here: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/employee#the-employee-object )