☁️ Power BI Service: The Cloud Environment

Once you have built a beautiful report in Power BI Desktop, it is trapped on your personal computer. To share it with your manager, you must click the Publish button.

This uploads your .pbix file to the Power BI Service (app.powerbi.com), which is Microsoft's cloud-based analytics platform.

🗂️ Workspaces

When you publish a report, you must choose a destination. That destination is called a Workspace. You can Create and organize workspaces by clicking "Workspaces" -> "Create Workspace" in the Service navigation pane. Best Practice: Use clear naming conventions for your workspaces to enhance usability!

A workspace is essentially a cloud folder where teams collaborate. It holds your datasets (semantic models), reports, and dashboards.

Workspace Roles

To maintain security and governance, you assign users to different roles inside a workspace. Always follow the principle of least privilege!

1. Admin: Full control. Can add/remove users, delete the workspace, and change all settings.
2. Member: Can add users (or entire Security Groups via Azure Active Directory) with lower permissions, publish reports, and edit content.
3. Contributor: Can publish and modify reports and datasets, but cannot add new users. (The ideal role for a developer!)
4. Viewer: Read-only access. They can click filters and read the report, but cannot change the charts or export raw data.

📈 Dashboards vs Reports

In the Power BI Service, there is a very strict distinction between Reports and Dashboards.

• Reports: What you built in Desktop. Multi-page, highly detailed, with cross-filtering and drill-downs.
• Dashboards: A feature exclusive to the Power BI Service! You cannot build a dashboard in Desktop. A dashboard is a single-page canvas where you "Pin" individual charts from multiple different reports. You can freely adjust the Dashboard layout by clicking and dragging tiles around the canvas.
  • Use Case: An executive wants a single page showing one chart from the Sales Report, one chart from the HR Report, and one chart from the IT Report. You create a Dashboard to consolidate them!
  • Real-Time Tiles: Dashboards can display streaming data that updates every second!

Dashboard Q&A

Dashboards include an AI search bar at the top called "Ask a question about your data". A user can literally type, "What were the total sales for France last year?" and Power BI will instantly generate a chart to answer the question using natural language processing!

📦 Power BI Apps

Giving executives direct access to a Workspace can be dangerous. It's cluttered, and they might accidentally click the wrong thing.

Instead, you bundle the finished reports and dashboards into a Power BI App.

• Apps vs Workspaces: Workspaces are the messy "kitchen" where developers build and edit reports. Apps are the "dining room" where business users consume the final, read-only product.
• An App is a highly polished navigation menu. You select exactly which reports to include, configure the audience, and publish it. When reports change, you must click Update App to push the changes to your users.
• You select exactly which reports to include, configure the audience (e.g., "Only the Finance Team can see the Finance tab"), and publish it.
• Users install the App on their phone or web browser and get a seamless, professional experience!

🏋️ Practice Drill

Let's explore the publishing workflow!

Task:

// Try answering these:
1. In Power BI Desktop, make sure you are logged into your Microsoft account (top right corner).
2. Save your file.
3. On the Home ribbon, click the **Publish** button.
4. Select "My Workspace" (this is your personal, private testing folder in the cloud).
5. Open your web browser, go to `app.powerbi.com`, log in, and click "My Workspace" on the left menu.

← ⏱️ Iterators and Time Intelligence | Next Topic → 🔐 Security, Refresh, and Deployment