All courses available in-class or via remote login

If you read the first post in this Power BI Seamless Integration series written by our Trainer Matt Burr, you will no doubt be keen to learn more. In the first post we delved into Apps that provide information to Power BI, now we will be looking into Apps that integrate directly with Power BI and how to deal with Administration.

APPS that interact with Power BI

1. Power Apps

Create code-free apps in minutes and share across your organisation. You can embed your Power BI tiles inside your PowerApps App OR using the PowerApps custom visual you can embed your PowerApps App inside your Power BI dashboard.

For example, this means that you can display your data insights in the Dashboard. Allowing your viewers to take direct action using the App (Think of an inventory dashboard with an embedded ordering App). You can also pass data from Power BI to your Apps!

2. Flow

    Create work flows across your data, apps and files to automate tasks.
  • Create data-driven alerts for your Power BI dashboard gauges, KPIs and cards then build flows that act based on your alerts – send emails, trigger an alert in Teams, create a Task in Outlook.
  • The number of flows you can create to update you Power BI data sources is only limited by your imagination and the 200+ Flow connectors.

3. SharePoint Online Modern pages

Easily insert a Power BI web part to display a Power BI report. In the Power BI service click File > Embed in SharePoint Online. Copy the displayed URL and paste it into the settings for the SharePoint Online Power BI web part.

Your Power BI report is now embedded in SharePoint – Simple!

(Just remember that your SharePoint site viewers will only be able to view the Power BI report if they have the appropriate permissions in Power BI)

4. SharePoint

Easily connect Power BI desktop to SharePoint lists and folders or SharePoint Online Lists or store your data source files on SharePoint for easy access and refresh.

 

5. Excel

  • One of the simplest data connections is connecting to an Excel workbook, make it easy by first creating Excel tables.
  • Analyze in Excel (an Excel Add-in) allows users to connect to the Power BI datasets and (as the name suggests) use Excel to analyse the data. From your report in Power BI Service click on Analyze in Excel to launch Excel.
  • From within Excel (Using the Power BI Publisher add-in) you can pin a selected range of data and share it to your Power BI report.

 

6. PowerPoint

PowerPoint and Power BI?! Surely they don’t have anything in common?...they do!

Currently PowerPoint is the only way that we can export our visuals out of Power BI (and only from the Power BI Service). Open your report and click File > Export to PowerPoint (Preview)

This will create a PowerPoint file with a cover slide and each report page to a slide.

Microsoft have just announced that you’ll soon be able to export to PDF from Power BI Desktop

 

Administration

1. Teams and Groups

In addition, when you create a Microsoft Team or a Microsoft Group you are also provided with a Power BI workspace (and vice versa). This becomes a useful and convenient way to manage permissions for Power BI sharing.

For instance, we use a Group for our training accounts.  This means we can easily manage our SharePoint permissions. We have a shared Power BI workspace, outlook folder, Teams channel, etc.

If I create a Power BI report in a shared workspace and embed it on a SharePoint Online site where the Group also have permissions. They can all view both the SharePoint site and the embedded Power BI report.

 

2. Office 365 admin

Microsoft Office 365 usage analytics within Power BI provides admin users insights into how their organisation is adopting the various services within Office 365 to communicate and collaborate. In addition, there are a number of reports available such as adoption, product usage, storage used, activations, as well as reports on individuals. However, this reporting must be enabled first.

 

To learn more about Power BI please check out our course offerings here. In addition, keep an eye out for our upcoming Office 365 beginner course. Learn about all of the new apps in the Office 365 range.

 

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23087 Reviews
Thanks Jason! I'll be back for intermediate and advanced very soon! -Excel Beginner Brisbane
JULIE - Excel Beginner, .
Michael was great. Very thorough, very open and responsive to questions and very clear in his approach to explaining functions etc. The ability to participate remotely was fantastic, and the blended class (we had 2 in Sydney and myself online) worked really seamlessly. Definately look at Nexacu for future training needs. -SharePoint Site Owner Sydney
Patricia - SharePoint Site Owner, .
This was a great course. I have learnt lots. Thank you. -SharePoint Site Owner Sydney
RaileighHumphries - SharePoint Site Owner, .
Great sessions and Michael was really helpful! -SharePoint Site Owner Sydney
Nathan - SharePoint Site Owner, .
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, .

Trusted by Business

Procured by Government

Map of Australia