Microsoft Power BI – Publishing to Power BI Service
NOTE: This is PART 2 of a 2-Part Microsoft Power BI series:
Up & Running with Power BI Desktop
Publishing to Power BI Service
Don’t forget to complete PART 1 to master Power BI Desktop!
Are you looking for a comprehensive, hands-on approach to learning business intelligence in the cloud with Power BI Service? You’ve come to the right place!
In PART 1, we began our deep dive into the #1 ranked business intelligence platform in the industry, and learned how to use Power BI Desktop to build complex data models, create calculated columns and measures with DAX, and design beautiful and interactive Power BI dashboards from scratch.
Now it’s time for PART 2: Power BI Service, where we’ll focus on publishing our Power BI reports to the cloud, sharing them across teams and organizations, collaborating with other users in real-time, and much more.
We’ll start with a quick orientation to the Power BI landscape and Power BI Service interface, introduce some common user personas (Creators, Analyzers, and Collaborators), and then systematically guide you through the key features of Power BI Service, including:
Connecting to Data from Power BI Service
Flat files, Excel workbooks, tables, Power BI reports, etc.
Configuring Gateways, Scheduled Refresh & Dataflows
Personal vs. Enterprise gateways, refresh settings, Power BI dataflows, etc.
Creating Power BI Reports & Dashboards
Reading vs. Editing views, pinning tiles & pages, assembling dashboards, etc.
Exploring & Analyzing Data within Power BI Service
Natural language Q&A, data-driven alerts, quick insights, bookmarks, etc.
Publishing, Sharing & Collaborating
Creating Apps, sharing Power BI workspaces, assigning user roles and row-level security, etc.
Using the Power BI Mobile App
Annotating, sharing, commenting, alerting, etc.
By the end of this course you’ll have a deep, practical understanding of Power BI Service, along with the skills and confidence you need to apply these tools to your own Power BI projects and analyses.
Whether you’re a casual Power BI user, aspiring analyst, or business intelligence professional, this course will give you the tools you need to become an absolute Power BI ROCKSTAR — guaranteed.
Hear why our Power BI Desktop and Power BI Service courses are the TOP-RATED on Udemy:
“I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn’t want to stop learning — I wanted to keep charging on to the next lesson!”
“Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI Service and in addition I have learned how to create a great course as well. Enjoyed the course from start to finish.”
“Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!”
“Where can I leave a 6 star rating?”
Join today and get immediate, lifetime access to the following:
Downloadable Power BI Service ebook (PDF)
Power BI project files & sample datasets
Course quizzes & Homework exercises (with solution walkthroughs)
Expert support & Q&A forum
30-day money-back guarantee
We can’t wait to see you in the course!
–Aaron & Chris (Maven Analytics)
P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for “Maven Analytics” and complete the courses below to become a business intelligence ROCKSTAR:
Excel Pro Tips for Power Users
Advanced Excel Formulas & Functions
Data Visualization with Excel Charts & Graphs
Data Analysis with Excel PivotTables
Excel Power Query, Power Pivot & DAX
Up & Running with Power BI Desktop
Publishing to Power BI Service
SQL Database Analysis for Beginners
Advanced MySQL for Analytics & Business Intelligence
Some features in this course require a Power BI PRO license (free 60-day trial then $9.99/month)
Power BI Service requires a school or work e-mail address to register (no personal email accounts like gmail, aol, yahoo, etc)
Walkthrough to cover exactly how the course is structured and what you need to know before diving into Microsoft Power BI Service.
In the last Getting Started section, I'll cover exactly what to expect (and what NOT to expect) from this course.
Introducing Microsoft Power BI Service
In this lecture, you'll meet Power BI Service. We'll discuss some of the features within the Service environment, talk about how Power BI Service fits into the Power BI ecosystem, and compare the Service features against Power BI Desktop.
In this section, we'll look at the three tiers of Power BI, Free, Pro, and Premium, dig into the features associated with each tier, and also talk about the cost of Power BI Pro.
Let's discuss the different ways types of users that interact with Power BI Service. We'll dive into typical Power BI user roles like creators, analyzers, and collaborators.
In this lecture we'll walk through how to sign into Power BI Service by creating a new Power BI account or signing in with an existing account.
In this lecture I'll introduce the Power BI Service interface, covering core views like, the Navigation Pane, Get Data button, Content Canvas, Search functionality, and the Help menu.
In this section I'll discuss some of the resources that I find most helpful, like the "Help & Support" menu, Microsoft Power BI blog, Microsoft Power BI YouTube channel, Guy in a Cube, and Power BI User Group (PUG).
Connecting to Data from Power BI Service
The Get Data menu is our portal for connecting to all kinds of data sources. While not as robust as Power BI Desktop, the data connection options in Power BI Service allow you to connect to apps created by your organization, various services (Github, Google Analytics, JIRA), files (csv, xlsx, pbix), and Databases (SQL, Azure, SSAS, Spark).
In this lecture we'll load our first dataset into Power BI, understand where the dataset is stored, and look at the Power BI Service features in a bit more detail.
This lecture continues to breakdown the components of Power BI. I'll show you the main building blocks of Power BI Service; Datasets, Reports, and Dashboards and how they come together to form Workspaces.
In this lecture we'll cover all the actions available in Power BI across our Datasets, Workbooks, Reports, and Dashboards and discuss a few of these actions in detail like, scheduled refresh, insights, delete, etc.
In this section I'll cover how to load an excel workbook to Power BI, discuss how the workbook is opened in an Excel Online environment, talk about the features and limitations of excel workbooks in Power BI Service, and pin pivot charts to a dashboard.
In this lecture I'll cover how to load tables from an excel workbook into Power BI Service to be used as datasets.
There are two types of workspaces in Power BI Service; My Workspace and App Workspaces. In this lecture, we'll compare and contrast the two workspace types.
In this lecture we'll create an App Workspace where you can share and collaborate with your coworkers. But before creating the app workspace, we first need to sign up for a Power BI Pro license trial.
In this lecture we'll continue to reinforce loading data, by using the Get Data menu, and load a .csv file into an app workspace.
In this section we'll load a complete data model, that was built in excel, into Power BI Service as a dataset. We'll also look at what gets imported like measures, calculated columns, and the underlying data relationships.
In this lecture I'll show you how to load a .pbix file by using the Get Data button from Power BI Service or by using the Publish button in Power BI Desktop.
Gateways, Refresh & Dataflows in Power BI Service
In this section we'll talk about data gateways, which act like a bridge between Power BI and your computer or server, and how they facilitate scheduled refresh within Power BI Service.
In this lecture I'll show you how to download the data gateway from Microsoft, walk you through setting up the gateway in personal mode, and then check Power BI to make sure the gateway is running.
In this lecture I'll show you how to enable scheduled refresh in Power BI and configure different options like frequency, time zone, and time of day.
In this section we'll set up the recommended Enterprise Gateway, set a recovery key, and confirm our gateway cluster running in Power BI Service.
Meet Dataflows - Query Editor processes that can be configured in Power BI Service to transform, enhance, and ingest your data. In this lecture we'll talk about why and how Dataflows can be used.
In this lecture we're going to walk through creating a new Dataflow. First, we'll talk about the process and then we'll jump into Power BI Service and create a Dataflow.
Designing Reports & Dashboards in Power BI Service
In this lecture we'll talk about how the basic building block in Power BI, datasets, are used to build reports and dashboards.
In this lecture we'll talk about the Reporting interface and the two different views: Reading View and Editing View. After each view is introduced, I'll walk you through the layout, features, and functionality.
In this section I'll show you how to add our first visual to the Power BI report canvas (stacked column chart) and cover the fields and formats options available for this specific chart type.
In this lecture we'll practice adding additional visuals to our Power BI report canvas; a date slicer and a matrix visual. We'll cover some of the formatting options available and also set up conditional formatting for our matrix.
Now that we've created a couple of visuals, I'll show you how to add these visuals to a Power BI Dashboard by pinning tiles.
In this lecture I'll show you how to pin a live page to a Power BI Dashboard and talk through the benefits of pinning a live page like, retaining tile interactivity and slicer functionality.
Have you ever wanted to create a dashboard from multiple Power BI reports? In this lecture I'll show you how to pin tiles from multiple disparate reports into one Power BI Dashboard
In this section we'll walk through the Power BI Dashboard interface, talk about the layout, features, functionality, and then jump into a hands-on demo where we'll add text boxes and schedule emails from Power BI Service.
In this lecture I'll show you how to set up data-driven alerts for three visual types; KPI cards, Cards, and Gauge charts.
In this lecture we'll explore the Power BI Q&A feature that uses natural language processing to help create visuals in Power BI Service.
In this lecture I'll show you how to generate Quick Insights in Power BI Service that will generate custom visuals and descriptions based on your dataset. Then, I'll cover how you can pin these quick insights visuals to a Power BI Report or Dashboard.
In this lecture we'll cover personal bookmarks in Power BI Service, which are bookmarks only accessible by you, and then we'll walk through how to add personal bookmarks in the report reading and editing views.
In this lecture I'll show you the difference between the Power BI Service web view and Power BI Mobile view and how the mobile view can be used to design custom Power BI mobile layouts.
Sharing & Collaboration Tools in Power BI Service
In this section we'll cover the last main function of Power BI Service, sharing with individuals, teams, and organizations.
In this lecture we'll cover the different ways to print or export a physical copy of your Power BI reports and dashboards.
In this lecture we'll publish our report to the web which creates a link that is accessible by anyone who has it. Publish to Web is a great way to share your Power BI Reports and Dashboards that do not contain sensitive data.
Want to give individual Power BI users access to the reports and dashboards in your app workspace? In this lecture I'll show you how you can share reports and dashboards with specific individuals.
In this lecture we'll talk about adding other users to our app workspaces as Admins, Members, or Contributors.
In this lecture we'll talk about Usage Metric Reports in Power BI Service. We'll dig into what they are, how they're created, and how you can take the Usage Metric Reports and customize them in Power BI.
In this lecture I'll show you how to define, configure, and test row-level security (RLS) in Power BI Desktop. After this is defined in Power BI Desktop, we'll publish to Power BI Service and test the roles to make sure they're functioning properly.
In this section, we'll look at how to create an app in Power BI Service. Once our app is created, I'll show you how to selectively add Power BI Reports and Dashboards to the app and how to update your Power BI app.
Power BI Mobile (PREVIEW)
In this lecture I'll provide an overview of the Power BI Mobile app and talk through the 4 core functions of the mobile app: Interact, Share, Draw & Comment, and Notify.
In this lecture I'll provide a live demo of the Power BI Mobile app and walk through all of the different features and functionality like, settings, favorites, notifications, apps, shared with me, workspaces, and scanner.
Complete the full stack of Excel, Power BI, and SQL analytics courses and emerge a certified wizard. Courses include Formulas & Functions, PivotTables, Charts & Graphs, Power Query, Power Pivot & DAX, Publishing to Power BI Service, and MySQL for Data Analysis (Beginner & Advanced).