FREE Power BI Syspro Sales Summary App

Need help getting started, email us at info@sysprobi.com

FREE Syspro Sales Summary (Power BI Template app)

I'm using SQL Server/SQL Database on Azure:

• Click here to find it on Microsoft AppSource

OR

• Navigate to the Power BI service navigation bar, click on 'Apps' and then select 'Get app'. In the Power BI app marketplace, choose 'Template apps' to browse or search for FREE Syspro Sales Summary.
• Once you have located the desired template app, click on it to view the details. On the template app offer page, select 'Get Now' to start the installation process.
• When the installation completes successfully, you'll receive a notification stating that your new app is ready to be used.

Connecting FREE Syspro Sales Summary template app to your data

Click 'Go to the app'. This will open the app with sample data. Next, click on the 'Connect your data' link in the banner at the top of the page.

Clicking on this link will open the parameters dialog box, complete the following Syspro specific parameters:

• Syspro SQL Server Name – Enter your Azure SQL Server name/address
• SysproSQLDatabase - Enter the name of your Syspro SQL Database
• Load History From Which Date - Enter the Start Date from when you want to load history (mm/dd/yyyy)
• Which Month Does the Fiscal/Fin Year Start - Enter the starting calendar month of the Fiscal/Financial Year

Authentication method dialog box:

• Authentication Method: Basic
• SQL Database Username
• SQL Database Password

After completing the connection dialogs, the connection process will begin. A banner will alert you that the data is being updated, and during this time you will continue to see the sample data.

The report data is automatically updated daily by default, unless you have chosen to disable this option while logging in.