Summary

This was a Microsoft Power BI training session focused on publishing and sharing reports through the Power BI Fabric platform. Mr. Dinesh explained the process of publishing Power BI reports to the cloud, including how to save reports, configure workspaces, and share dashboards with different users and departments within an organization. The session covered various sharing methods such as email, Microsoft Teams integration, PowerPoint presentations, and SharePoint embedding, as well as how to create dashboards by pinning visuals from multiple reports together. Mr. Dinesh also demonstrated how to configure data refresh schedules, set up role-based access control for different departments or regions, and use the mobile app for on-the-go access to reports. The session concluded with information about upcoming Power BI certification opportunities and a special class on Power Automate and Power Apps scheduled for the following day.

Power BI Report Development Discussion

The team discussed Power BI report development, with Dinesh emphasizing that while Power BI is a complex subject, it's important to create practical dashboards that deliver real value to end users. Dinesh explained that out of 10 people who start Power BI projects, only 2-3 typically complete them successfully. The discussion focused on report customization and publishing, including how to connect data sources and hide certain pages in reports, with Dinesh demonstrating these concepts using a masked dataset example. Riadh requested screen sharing during the presentation, which Dinesh confirmed was already active.

Power BI Cloud Publishing Process

Riadh demonstrated the process of publishing a Power BI report to the cloud using the Fabric platform. He explained that once a report is completed and finalized, authors can publish it to Power BI by clicking the File button and selecting Publish, which allows sharing with specific teams or the entire organization. Riadh noted that while companies like Qatar LNG might have organization-wide access for around $5,000 per month, individual users cannot publish directly to the cloud with personal accounts, requiring either a company account or student account for publication access.

Power BI Report Sharing Methods

The team discussed how to share Power BI reports with colleagues who don't need Power BI access. They explained that reports can be shared via email or Microsoft Teams, with the advantage in Teams being the ability to post reports in specific team channels. The team also demonstrated how to embed Power BI reports in external websites, including their LMS portal, by adding the report URL to a Teams channel or directly to an external website.

Power BI Sharing Methods

The team discussed how to share and embed Power BI reports using different methods including Teams, Outlook, PowerPoint presentations, and SharePoint websites. They demonstrated that once published to Microsoft Power BI Fabric, reports can be shared via direct links or embedded dynamically into PowerPoint presentations, allowing viewers to see live data while maintaining a professional format. The discussion also covered how reports can be downloaded back to Power BI Desktop and embedded into public websites or SharePoint intranet sites using web parts.

Power BI SharePoint Publishing Guide

The team discussed how to publish Power BI reports to SharePoint websites, explaining that reports can be added as web parts without requiring specialized IT knowledge or coding. They explained the concept of semantic models and how data refreshes work, noting that when data sources are updated (like from Excel sheets to ERP systems), the refresh frequency settings can be configured to update automatically from every 15 minutes up to real-time, though real-time updates require additional payment for real-time intelligence in Microsoft Fabric.

Power BI Fundamentals Training

The team discussed Power BI fundamentals, including how to publish reports and configure automatic data refresh in semantic models. They clarified that when data improves, users don't need to manually refresh and republish datasets, as Power BI will automatically handle this. The discussion also covered organizing reports into folders and workspaces, and demonstrated how to access published reports through the mobile Power BI app, which allows executives and CEOs to view reports on-the-go with zoom and landscape viewing capabilities.

Power BI Alerts Configuration

The team discussed how to configure alerts in Power BI using Fabric, explaining that users can set up notifications for specific KPI thresholds by clicking the bell icon in the visualizations. They demonstrated how to create an alert for when total sales after discount exceeds 2 million, which would trigger notifications through Teams or email. The team emphasized that Fabric makes reports intelligent by enabling mobile app access, embedding in various platforms like PowerPoint and Teams, and providing automated alerts, with video recordings available in the Team Academy LMS portal for reference.

Power BI Dashboard Creation Discussion

The team discussed creating dashboards in Microsoft Power BI to address the challenge of executives receiving multiple unconnected reports via email. They explained how to create a dashboard by pinning specific visuals from existing reports into a centralized dashboard, using the CEO Dashboard for Labs as an example. The instructor announced plans for a future contest where students would create dashboards on their domain areas, with free PL-900 exam vouchers offered as incentives, potentially scheduled for July or August.

CEO Dashboard Creation in Power BI

The meeting focused on creating CEO dashboards in Power BI, where participants learned how to pin visuals from multiple reports into a single dashboard and configure data access permissions using roles. The instructor demonstrated how to publish reports to Microsoft Fabric and explained the process of creating role-based access for different regions and departments. The session concluded with information about an upcoming Copilot training demo class and instructions for obtaining certificates from Team Academy.