Microsoft PowerBI: Displaying Acumata Data in the Cloud outside the Acumatica ERP

Summary

Microsoft PowerBI is a cloud/online graphic reporting tool that can store external data such as Acumatica data, and display it online in many formats such as tables, charts, maps, etc. The advantage of this tool is that it is in the cloud, and that people can have access to this data without needing access to the Acumatica ERP. Also this data in MS PowerBI can be manipulated, and joined by data from other external resources such as other applications and databases.

In Acumatica, the Generic Inquiry writer can be used to retrieve any data in Acumatica—including data stored in customized fields—and publish it, export to Excel, or format it for OData. The OData formatting option exposes the data in the Open Data Format supported by business intelligence tools like Microsoft Power BI.

Videos (5 mins, 2016) shows how easy it is to set up a MS PowerBI site in the cloud

Videos (8 mins, 2017) shows how easy it is to display Acumatica data in a MS PowerBI site in the cloud

Features of MS PowerBI

MS PowerBI has been enhanced a lot. 

The video (8 mins, 2020) shows the latest. 

Internet Customer Solutions, Inc.

153 Autumn Ridge Rd, Suite 10

Morris Plains, NJ 07950

(o): 973 244 1470

(c): 973 727 9665

info@intercs.com

MS Teams: ToonSix@internetcs.onmicrosoft.com

Contact Us

  • LinkedIn Social Icon
  • Facebook - Black Circle
  • Twitter - Black Circle
  • Google+ - Black Circle

© 2018 by Internet Customer Solutions