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.

 

Why choose Nexacu?

Valued by Individuals

4.8/5
Over 15837 Reviews
Training is really good. Topics selected were good and all questions were answered patiently. Will prefer this facilitator for the next sessions. -Power BI Intermediate Canberra
suz - Power BI Intermediate, .
Great course, great trainer learned alot -Analysis & Dashboards Brisbane
Karen - Analysis & Dashboards, .
Found it to be very informative. Now I need to go and put it into action. Jagg was an excellent trainer, just the right level of understanding of the differing skills in the room. -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
Thank you -Power BI Intermediate Canberra
Anon - Power BI Intermediate, .
Great -Power BI Intermediate Adelaide
David - Power BI Intermediate, .
Good trainer who made sure I understood everything and took the time to cover any queries I had. Very interactive which really helped my understanding. -Analysis & Dashboards Brisbane
Amy - Analysis & Dashboards, .
Thank you -Analysis & Dashboards Brisbane
LGC - Analysis & Dashboards, .
Excellent Trainer -Power BI Intermediate Canberra
Prakash - Power BI Intermediate, .
Thanks! -Power BI Intermediate Canberra
GP - Power BI Intermediate, .
Thanks. Good efficient course and engaging instructor! -Power BI Intermediate Canberra
Elise - Power BI Intermediate, .
Great knowledge of the trainer, who provided data insight and visualisation advice for various audience -Power BI Beginner Melbourne
Zoe - Power BI Beginner, .
Comprehensive and great for beginners -Power BI Beginner Melbourne
mlim - Power BI Beginner, .
clear teaching -Power BI Beginner Melbourne
Lay - Power BI Beginner, .
thanks John -Power BI Beginner Melbourne
dh - Power BI Beginner, .
John was great to work with. Really enjoyed his style and patience with us. Thanks John! -Power BI Beginner Melbourne
David - Power BI Beginner, .
Good pace and engagement. Answered questions well. Friendly and pleasant. -Power BI Beginner Melbourne
John - Power BI Beginner, .
A thorough overview of analysis and dashboards and the intrinsic possibilities -Analysis & Dashboards Melbourne
LUMART - Analysis & Dashboards, .
Tim was very clear and easy to understand and took the time to understand what we did for our jobs and tried to then give useful examples as to how we could use these tools in our work. -Analysis & Dashboards Melbourne
Nicola - Analysis & Dashboards, .
Very insightful session into Power BI, will definitely come back for another level so I could leverage the tool for the business -Power BI Beginner Melbourne
Tham - Power BI Beginner, .
Good course -Analysis & Dashboards Melbourne
Lauren - Analysis & Dashboards, .

Trusted by Business

Procured by Government

Map of Australia