All courses available in-class or via remote login

Series Recap

In Episode 1 and Episode 2 we detailed the steps to:

  1. create a Questionnaire or Survey in the Microsoft Office 365 App Forms
  2. use the Flow App to capture the response data. Then save it to a SharePoint Online List or push it to a Power BI streaming dataset.

In Episode 3, we will show how to:

  • connect to those data sources in Power BI,
  • embed the Report into SharePoint Online.

 

Connecting to a streaming dataset (or other datasets already on the Power BI service)

We can do this two different ways.

In the Power BI Service (accessed via app.powerbi.com) we can navigate to our Workspace and click on the streaming dataset we created earlier on our bottom left-hand corner. Then we can start creating our Report:



The Power BI Desktop also allows us to connect to datasets that are stored in our Power BI Service Workspaces. In Power BI Desktop, click Get Data and then select Power BI datasets:

 

Integrating Forms

Then you can browse to your Power BI Workspace, select the dataset and click Load:

 

Integrating Forms

 

Connecting to a SharePoint Online List

Power BI also makes it very easy for us to connect to a SharePoint Online List, click on the top half of the Get Data button, Search for “SharePoint”, select SharePoint Online Lists and click Load:

Integrating Forms

We then need to insert the URL of our SharePoint Online site. The URL should include up-to and including the site name and the forward slash after the name:

Integrating Forms

Then select the desired list you want to connect to and click Load:

Integrating Forms

Once we connect to our data and create our Report, we can then upload the Report to the Power BI Service. If you connected to a Power BI dataset, your Report will upload to the same Workspace.

Integrating Forms

View the web published version of the SharePoint List version here: https://app.powerbi.com/view

 

Embedding Power BI reports in SharePoint Online Pages

Once we have created our reports in Power BI Service, we can get an embed code for SharePoint Online. Click on File > Embed in SharePoint Online

Integrating Forms

Copy the URL that is provided.

Browse to your SharePoint Online site, and in the page where you want to insert the Report add a Power BI web part:

Integrating Forms

Click on Add report (or edit the web part). Then insert the URL provided from Power BI Service (when you clicked “Embed in SharePoint…”

Integrating Forms

Ensure the options suit your needs: choose a Page, Display and if you want to show the Navigation or Filter Pane.

 

It’s important to note that users accessing the SharePoint page will also need the correct permissions to view the Power BI Report. One good way of managing this is to use Office Groups in both Power BI Service and SharePoint, that way everyone in the same group can see the Report and access the SharePoint site.

Done!



To learn more about Power BI, SharePoint or Office 365 apps check out our courses or webinars from Matt!

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23083 Reviews
The course provided a great base to continue my learning with Power BI. -Power BI Beginner Melbourne
Chris - Power BI Beginner, .
John was direct and concise with his delivery. As a Supervisor I am now more prepared to request reports of the types I require . Long day but excellent information and paced well. Thank you -Power BI Beginner Parramatta
Glenda - Power BI Beginner, .
Very interesting course. John was great but the course was a lot to take in one day, maybe it should be split into 2 sessions over 2 days. -Power BI Beginner Melbourne
kaan - Power BI Beginner, .
Very informative and easy to follow. Patient and communicated well Now have a better understanding of how to set up Power BI reports. -Power BI Beginner Melbourne
Melanie - Power BI Beginner, .
Steven has a great knowledge and great present skill for the day. the course was well designed. satisfied with everything. Thank you -Power BI Beginner Brisbane
Megan - Power BI Beginner, .
Hands on, enjoyable training. Thank you Steven -Power BI Beginner Brisbane
Catalina - Power BI Beginner, .
Good intro into the world of Power BI. Hope to be able to put it into practice straight away -Power BI Beginner Brisbane
Raelene - Power BI Beginner, .
Useful course and excellent trainer -Power BI Beginner Brisbane
Rajesh - Power BI Beginner, .
Course was well structured and paced. Steven was a knowledgeable instructor. -Power BI Beginner Brisbane
Brianna - Power BI Beginner, .
Really good fun and informative with Steven, as always. -Power BI Beginner Brisbane
James - Power BI Beginner, .
Thank you! See you again for intermediate and advanced -Excel Beginner Brisbane
JULIE - Excel Beginner, .
Jason was an awesome instructor that had my full attention for the duration of the course. I really enjoyed the hands on experience & being able to follow along with my own laptop. Thank you for an amazing course! -Excel Beginner Brisbane
Emma - Excel Beginner, .
Well delivered class! Definitely learnt a lot and had a laugh which was good. Thank you Jason, you're an excellent teacher. -Excel Beginner Brisbane
Layla - Excel Beginner, .
Very much enjoyed the course, easy to understand and follow, I feel like I have a better understanding of the program now so thank you Jason! -Excel Beginner Brisbane
Serena - Excel Beginner, .
Excellent course -Excel Beginner Brisbane
Nahan - Excel Beginner, .
AMAZING! So grateful I completed this. See you for intermediate and advanced soon :) -Excel Beginner Remote Online
JULIE - Excel Beginner, .
made sense of what i have been trying to achieve since moving into an office environment -Excel Beginner Brisbane
Joseph - Excel Beginner, .
Excellent trainer -Excel Beginner Brisbane
Peter - Excel Beginner, .
Really helpful - good teacher -Excel Beginner Brisbane
Martin - Excel Beginner, .
Great session with Jason as always -Excel Advanced Remote Online
Rebecca - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia