Microsoft 365 training and content for modern digital workplaces
Did you know you can adjust the page size of your reports in Power BI? Each tab/page of your report can be a unique size specified by you down to the pixel. This comes in handy for creating “widget-like” visuals for embedding or for creating reports for print and optimal display on various screen sizes.
Your options are:
If you’re on-premises and looking to embed a Power BI Report Server report in SharePoint, you’ll find it’s not as easy as O365 embeds. But it’s certainly possible; here’s how:
Continue reading “Embedding Power BI Report Server (PBIRS) reports in SharePoint”
I recently set out to create a “live” conference room schedule that could be presented constantly on an auto-refreshed screen outside conference rooms. This would replace printed schedules placed in holders outside the rooms. The following example uses a SharePoint calendar as the conference room calendar and can be refreshed constantly using Power BI’s scheduled refresh in O365 or Report Server.
Continue reading “Use Power BI to create a dynamic/live meeting room schedule”
Automatically create and send reports, files and lists on a regular schedule using Microsoft Flow’s recurrence trigger. Whether hourly, daily, weekly or monthly you can deliver the most current and relevant data from SharePoint or OneDrive to interested parties via email without lifting a finger. Combine this with calculated columns in SharePoint and conditions for some awesome possibilities:
| Alerts | Calendar | Relevance | Routine |
| Report costs or expenditures above a certain amount | Current month’s birthdays and/or workiversaries to your secretary | Send expenses per department or individual to that department or individual | Budget and salary or payroll figures weekly |
| Notify when an open ticket is idle for a week or incomplete | Upcoming events per location | Share evaluation status with supervisors for just their employees | Recently closed deals and contracts |
| Survey responses or reviews under 3 stars | Upcoming deadlines per department | Client info and updates to proper salespeople based on location or product | Distribute new hires’ contact/location info to the organization in weekly batches |