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.

 

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21470 Reviews
Jagg was an excellent trainer - very patient, had lots of options for people who didn't have the newest versions. I feel really confident about what I learnt today and I am very happy I did this course! -Power BI Beginner Adelaide
Melissa - Power BI Beginner, .
Excellent! Very knowledgeable instructor. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
Great course, very informative. Great instructor, very helpful -Power BI Beginner Adelaide
Sarah - Power BI Beginner, .
Great session, moves at a good pace with support when needed. Thanks -Power BI Beginner Adelaide
Matthew - Power BI Beginner, .
Excellent! -Microsoft Applications - Customised Sydney
Candice - Microsoft Applications - Customised, .
Very helpful -Microsoft Applications - Customised Sydney
Janet - Microsoft Applications - Customised, .
The learning environment and facilities are great. Ken knew the course content and is a friendly trainer.. -SharePoint Site Owner Melbourne
Robbie - SharePoint Site Owner, .
Thank you Ken Great 2 day of learning lots of information, looking forward to making our New Company SharePoint Site -SharePoint Site Owner Melbourne
Natasha - SharePoint Site Owner, .
Thank you Ken, I feel a lot more empowered and up-skilled with regards to SharePoint. I am looking forward to supporting my organisation to leverage SharePoint as one of collaboration and information management tools. -SharePoint Site Owner Melbourne
Annita - SharePoint Site Owner, .
Found it beneficial. Ken was extremely knowledgeable -SharePoint Site Owner Melbourne
Toby - SharePoint Site Owner, .
Great course, learnt a lot for the trainer. -Power BI Beginner Sydney
Aaron - Power BI Beginner, .
A good session however some revision of content from the intermediate course, which meant doing those two courses close together made those portions somewhat repetitive. Jagg was a good presenter and a good pace. -Excel Advanced Adelaide
Belinda - Excel Advanced, .
Jagg went above and beyond to help us learn the advance functions of excel. -Excel Advanced Adelaide
Ateeq-ur - Excel Advanced, .
Jagg was a great instructor - he stepped us through at a good pace, paused well to take q's and was well prepared. -Excel Advanced Adelaide
Hannah - Excel Advanced, .
Excellent range of advanced skills presented -Excel Advanced Adelaide
Oliver - Excel Advanced, .
Jag was excellent! Clear and thorough. I was a bit worried doing it remotely but found it better! Highly recommend. -Excel Advanced Adelaide
Agland - Excel Advanced, .
Was a very good informative session from Jag. -Excel Advanced Adelaide
Nilmini - Excel Advanced, .
Thank you. Well taught, clearly presented, and valuable lessons. Would recommend. -Excel Advanced Adelaide
David - Excel Advanced, .
Good pace, great course -Excel Intermediate Melbourne
Gemma - Excel Intermediate, .
Was a very informative course. John is a very patient instructor. Gives clear instructions. -Excel Intermediate Melbourne
Sonia - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia