Pull all your data from eHour in Microsoft Excel or Power BI using a new reporting endpoint. Any column that you need for analysis can be selected - custom fields, hours, comments, rates, project info, etc.
You can connect to the endpoint from Power Query, then transform the data into the shape you want, and quickly be ready to create reports and insights. Once you have set up the connection between eHour and Power Query, use the refresh button in Excel to pull in new data.
Power Query is available in Power BI and Excel 2010 and up.
Read more about setting up the connection in our knowledge base.