Power BI Service
Power BI · Power BI Service
Theory
The Power BI Service is the cloud platform at app.powerbi.com where published content lives. When you publish a .pbix file from Desktop, it becomes two items in a workspace: a semantic model (the data and model, formerly called a dataset) and a report connected to it. In the Service you organise content in workspaces, schedule data refresh, connect to on-premises sources through a gateway, build dashboards, publish apps, share content, set up row-level security members and subscribe people to email snapshots.
For example, after publishing 'Sales Overview' to the Sales Analytics workspace, you open the semantic model settings, enter the data source credentials, set a daily 7 AM refresh, and publish an app so the regional managers in Jaipur, Pune and Chennai can open the report from the Apps list or the mobile app. Reports can also be edited lightly in the browser, but heavy modeling stays in Desktop.
Why we use it
Desktop alone keeps a report on one laptop. The Service makes it shared, secure, refreshed automatically and available on any device, which is what turns a file into a business tool.
When to use it
Publish to the Service as soon as anyone else needs to see the report or data must refresh unattended. Keep authoring and model changes in Desktop, and manage environments with separate workspaces (for example Dev and Prod).
How it works
- Report finished in Desktop
- Home → Publish to a workspace
- Configure credentials and refresh on the semantic model
- Do on-premises sources need refreshing? Yes: Map them to a data gateway. No: Cloud sources refresh directly.
- Share via app or workspace access
- Users consume the report anywhere
Syntax
Desktop → Home → Publish → choose workspace
Service: Workspaces → [workspace] → semantic model → ... → Settings (credentials, refresh, parameters)
Report → Share | Subscribe | Export
Workspace → Create app / Update appExample
1. Desktop: Home → Publish → 'Sales Analytics'.
2. Service: open the workspace; you see the 'Sales Overview' report and semantic model.
3. Semantic model → Settings → Data source credentials → sign in.
4. Scheduled refresh: On, daily at 7:00 AM, time zone (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi.
5. Workspace → Create app → add the report → audience: Regional Managers → Publish app.Key points
- Publishing creates a semantic model and a report in a workspace
- Workspaces organize reports for teams
- Scheduled refresh keeps published data current
- Row-level security members are assigned in the Service
- Apps package workspace content for broad audiences