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 […]
5 Big Enhancements to a SharePoint Vacation Tracker in Microsoft Lists
Intro In a previous blog post I created a Vacation tracker in a SharePoint List and in this post, I’ll be adding enhancements to the list. These enhancements are fairly straight forward and will improve the vacation tracker’s functionality. I’ve received several comments on my Vacation Tracker YouTube video with viewers asking for additional features […]
Directly Query a Power BI Dataset Using Power Automate and Save it to Excel in SharePoint
Intro: I received a request from one of my viewers for help in developing a Power Automate flow and after completing the flow decided to do a blog post and YouTube video on it. The Request: I decided to take it one step further by removing the need for the Power BI Export button and […]
How to Export a Large Filtered SharePoint List into a CSV File Using Power Automate
In the previous post I imported 100,000 rows of data from Excel into a SharePoint List using Power Automate. In this post, I will export a large amount of filtered data out of the same SharePoint List and into a CSV file using Power Automate. Within Power Automate, I’m just using a manual trigger and […]
How to Import a Large Excel Dataset into SharePoint Using Power Automate
In this blog post, I discuss how to import 100,000 rows and 56 columns (5.6m data points) into a SharePoint List (Microsoft Lists) from a Microsoft Excel csv file using Power Automate. I downloaded a 1.8 GB csv dataset from Kaggle with 495,000 rows and 89 columns and transformed the data into two 50 MB […]
SharePoint Team Vacation Tracker
Today we are going to discuss how to setup a team vacation tracker in SharePoint using Microsoft Lists. Once the list is completed, we will integrate it into Microsoft Teams. While working at Microsoft, my boss asked me to create a team vacation tracker in Excel to provide visibility and ensure redundancy while members of […]