Required Permissions
- To install SPPAS, you must be a Global Office 365 Admin or SharePoint administrator.
- You need to be the Site Collection Administrator for the Site Collection you are installing SPPAS on
- You need to be a Power BI administrator or a User with permission to install Power BI apps.
Install from App Source
Go to Microsoft App Source and click Get it now
Then select Add to app catalog.
Figure 3.1.3 SPPAS details page
Confirm data access by clicking Add.
Figure 3.1.4 Confirm data access dialog
Create a Communication or Team Site
Sign-in to SharePoint Admin.
Sign-in to SharePoint admin center. If you want to use a communication, follow instruction in 5.2. If you want to use a team site, follow instructions in 5.3. We recommend using a communication site.
Create a Communication Site
Select Active Sites, then click + Create site and choose the Other option.
Figure 4.2.1 Choose site page
Figure 4.2.2 SharePoint communication site form
- Give your new team site a name and, in the Primary administrator, select yourself as primary administrator.
- Select a language for your site and time zone.
Click Finish.
Enable the “Limited-access user permission lockdown mode”
To prevent users from accessing the Sharepoint list and site directly to prevent unwarranted modification, we must activate this site collection feature.
Go to
- Site Settings > Site collection features > Limited-access user permission lockdown mode.
- Click on Activate
Figure 4.4.1 Site collection features page
Install SPASS in the Site
From the Team site you just created, go to Settings and then select Add an app.
On the filter on the left, choose From my organisation. Search for SPPAS and select to install on the site.
Figure 5.1.2 Add SPPAS page
Verify that SPPAS is installed
After you’ve installed an app, you can find it in the Site Contents page. Go to Settings , select Site contents, and your app will be listed.
Figure 5.2.1 Content site page
Verify that additional lists have been created.
Create a full-page app in SharePoint
From the home page of your site, click New and then click Page.
Figure 6.1.1 Team homepage
Add SPPAS to page
Click the Apps tab.
- Select the SPPAS app you installed.
If it does show immediately, click the templates tab, then the app tab again.
You should not be worried if the preview shows there is an error.
Figure 6.2.1 Add full-page app form
Click Create page.
Wait while the application installs
Give the page a name
Figure 6.3.1 Property page form
- Enter a name for your page.
- Clear the Show in site navigation checkbox
- Fill in the other options may be available in the App page details pane.
Publish the Page
When you are ready for the page to be visible to your page viewers, click Save.
Make the page Home Page
Go to Site Contents > Site Pages.
- Select the page you publish above.
- Click on the more (ellipses icon), and select Make homepage
Figure 6.5.1 Team site pages
Install the Power BI report
Go to https://appsource.microsoft.com and search for SPPAS Dashboard or use this direct link.
Figure 7.1.1 Appsource
Then, select Get it now. Confirm that you want to install this app.
Figure 7.1.2 Install SPPAS Dashboard page
The Power BI service displays a success message once the app is installed.
Figure 7.1.3 Confirmation page
Select Go to app. The app opens, showing sample data.
Connect to your own data
Select the Connect your data link on the banner at the top of the page.
Figure 7.2.1 Power BI dashboard
This opens the parameters dialog, where you change the data source from the sample data to your own data source (see known limitations), followed by the authentication method dialog. You may have to redefine the values in these dialogs.
Figure 7.2.2 Power BI parameters page
Once you’ve finished filling out the connection dialogs, the connection process starts. A banner informs you that the data is being refreshed, and that in the meantime you are viewing sample data.
Figure 7.2.3 Power BI dashboard
Your report data will automatically refresh once a day, unless you disabled this during the sign-in process. You can also set up your own refresh schedule to keep the report data up to date if you so desire.