Backup an Azure SQL Database to a Lakehouse Using Microsoft Fabric
Intro I’m part of a team who manages an Azure SQL database with over 300 tables and 30 GB of data as part of my role as Power Platform Developer at my current contract. We looked at several different backup options and decided to import the entire database into a different Lakehouse by running a […]
SharePoint List Vacation Time Off Tracker that Removes Weekends and Holidays
After receiving many comments from two previous posts based on Vacation Trackers in SharePoint, one such area of interest is around automating the calculation of time off that includes factoring in weekends and holidays. This is what we are going to tackle in this post. The two previous vacation tracker posts are below:SharePoint Team Vacation […]
Get a Custom Project Tracker Up and Running in Minutes with Dataverse
Intro In this post we are going to look at creating a Project Tracker application in Power Apps using Dataverse and Model-Driven apps. I’ve previously built a project tracker using a SharePoint Lists which is a good tool for this, click here to see that post. It’s even possible to use SharePoint Lists as a […]
Populate a SharePoint Document Library’s Metadata Using JSON and Power Automate
Intro In this blog post, I discuss how to save a PDF document to a SharePoint Document Library, with some of its content previously extracted via AI, and saved in a JSON file, that will populate multiple Document Library columns using Power Automate. Imagine we receive these documents and possibly other files via email from […]
Why Use Microsoft Teams Channels for Project or Program Management in 2024?
Intro If your organization uses Microsoft Teams, you know it’s a great place for individual and group chats, much like any other instant messaging service. Outside of Chats are Teams, which are where people come together to get big things done. If you have a project or program, creating a Team (in Teams) can be […]
How to Setup Microsoft Fabric Capacity for a Power BI Workspace from the Azure Portal
Intro If you are new to setting up Microsoft Fabric then this is the post for you. It walks you through step by step on how to setup Fabric capacity from the Azure Portal and then add that capacity to a Power BI Workspace. From the Azure Portal From within Azure Home, either create a […]
How to Access a SharePoint Site’s User List in Power BI
Intro I wrote a post not that long ago demonstrating how to create project status reports from a SharePoint List using Power BI (click here to go to that post), and in this post, I will show two examples on how to view the SharePoint User Lookup field in those Power BI Reports. The below […]
Automatically Refresh Power BI Report Data
Intro In this post, I discuss how to keep your Power BI dataset automatically refreshed with the most current data. Keeping your PBI reports up to date is crucial for making informed decisions. Microsoft Power BI offers two ways to ensure your data is always fresh, manual refresh and automatic, and we will discuss both. […]
Create Project Status Reports from a SharePoint List Using Power BI
Intro In my last post I built a Project Tracker in a SharePoint/Microsoft List (Click here to see that post), today I’m discussing how to build reporting in Power BI that directly connects to the dataset in that SharePoint List. Power BI provides advanced reporting capabilities and connects with many types of data sources to […]
SharePoint Project Tracker
Intro In this post, I discuss how to use Microsoft (SharePoint) Lists to track projects. Although Microsoft Planner is a great tool and Microsoft Project is fantastic as well, sometimes you need more customization that is not readily available in those two applications. With Microsoft Lists, you start with a blank slate, it is completely […]