Getting data from a file, such as Excel, CSV, XML, or text, is the most straightforward method of getting data into Power BI. We'll start here with an Excel file. Download and install the Power BI Desktop from www.PowerBI.com before you begin.
Note
Your Power BI Desktop may look a little different than mine, based on when you downloaded it, although the foundation will remain the same. A new version is released every month.
Our goal here is to solely connect the data in an Excel file to the Power BI Desktop and import the data into the in-memory data model for Power BI. This will allow the data to reside in Power BI for use with its many visuals:
Open Microsoft Dynamics GP SmartList and export the default SmartList
Customers Balance *
to Excel and Save:Open Microsoft Power BI. Upon opening it, you may receive a Getting Started window. This window contains links to the last few dashboards you've built, such as POWER BI BLOG, FORUMS, TUTORIALS...