[Power BI] Connecting Power BI to an Excel File Stored on Microsoft Teams, SharePoint or OneDrive as a Data Source

Level of Difficulty: Beginner – Senior. Power BI reports are a quick and easy way to visualise existing data. Often, we want to visualise data from flat files that aren’t necessarily stored on our local computer but rather, files that are modified by other contributors. By storing a file on OneDrive or SharePoint (or indirectly,Continue reading “[Power BI] Connecting Power BI to an Excel File Stored on Microsoft Teams, SharePoint or OneDrive as a Data Source”

[Power BI] Creating a Hamburger Menu for Filters in Power BI

Level of Difficulty: Beginner – Senior. Often we create Power BI reports that require some sort of filtering mechanism but filters take up a lot of real-estate that could be used for other visuals instead. What if we could hide and show a filter pane using a “hamburger” menu mechanism? We can and here’s how.Continue reading “[Power BI] Creating a Hamburger Menu for Filters in Power BI”

[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams

Level of Difficulty: Intermediate to Senior. So you’ve reached created a database, you’ve created schemas and tables. You’ve managed to create an automation Python script that communicates with the database, however, you’ve reached a crossroad where you need to validate your SQL tables. Some of the validation might include ensuring that the tables exist andContinue reading “[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams”

[RPA]: Using The Microsoft Office 365 Activity For Sending Emails in UiPath

Level of Difficulty: Beginner. This post will assist in using the Microsoft Office 365 Activity, specifically for sending emails with attachments, in UiPath. What are the steps? The steps that we will be following are: Follow the link on how to create an App Registration on Azure Get the Application ID and Tenant ID fromContinue reading “[RPA]: Using The Microsoft Office 365 Activity For Sending Emails in UiPath”