Recently, I created several Power BI visuals on Dynamics GP data and had a request to share the SQL scripts I used to import into my Power BI model’s datasets. The previous Power BI datasets and visuals included:
- General Ledger financial statement and analysis
- Inventory reorder point analysis
- Procurement analysis
- Sales summary
- Customer analysis
- Sales Return (RMA) analysis
Most of the scripts where SQL views and can be used to import into Power BI or in SSIS to import into a Data Mart. Some SQL scripts will need to be changed to meet your needs or fit your environment. The zip file can be found here. Hope this helps with your quest for knowledge.