What is the Best way to access Acumatica Data

[LijunChen]

Hello All,

Recently I am asked to create a Power BI dashboard to track the time / budget for different projects. The time cards and projects budget/costs for all our projects are all in Acumatica online portal. I have been given access to some data in Acumatica and can run some queries. I would like to connect the data sources to Power BI and create tracking visuals for the time and budget used for a project.

I would like to know What is the best way to set up connection to the Acumatica data sources? Is it easy to create Odata queries and set up connection with Power BI? Will the Odata source from the query be automatically updated with latest data? I am not an IT guy, so I hope there is some easy solution without complicated coding involved. 

Thanks. 

[foodd]

Acumatica Data Visualization Tutorial, using OData and Power BI