Level of Difficulty: Beginner – Senior. As a follow-on from the post written comparing UiPath to the Microsoft Power Platform, this post aims to unpack the different licenses and licensing strategies implemented by the two different vendors. Since both are leaders in the automation space, it is apt to understand both when evaluating the feasibilityContinue reading “[Et al.] Understanding UiPath Licensing Compared to Power Platform Licensing”
Category Archives: Power BI
[UiPath] Setting up a Power BI Custom Connector for UiPath Data Service
Level of Difficulty: Intermediate – Senior. UiPath Data Service has become a sophisticated way to encapsulate data and information used in automation solutions within the UiPath platform without needing to invest in additional infrastructure. The power that data enables which ties everything together is the ability to integrate and visualise the available data. For this,Continue reading “[UiPath] Setting up a Power BI Custom Connector for UiPath Data Service”
[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source
Level of Difficulty: Beginner – Senior. The market for data collection, visualisation and analysis tools spans across many different providers on many different platforms and in some cases, the best way to become exposed to the variety of tools is by mixing and matching between them. So why not visualise a Google Sheet on PowerContinue reading “[Business Intelligence] Connecting a Google Sheet to Power BI as a Data Source”
[Automation] Retrieve Power Automate Flow Run Logs and Visualise in Power BI
Level of Difficulty: Intermediate – Senior. This post will focus on pulling the Power Automate flow run logs, using PowerShell, exporting them to a CSV file and visualising them in Power BI What are the steps? The steps that we will be following are: Setup PowerShell Get the data Visualise in Power BI Setup PowerShellContinue reading “[Automation] Retrieve Power Automate Flow Run Logs and Visualise in Power BI”
[Business Intelligence] 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 “[Business Intelligence] Connecting Power BI to an Excel File Stored on Microsoft Teams, SharePoint or OneDrive as a Data Source”
[Data Visualisation] 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 “[Data Visualisation] Creating a Hamburger Menu for Filters in Power BI”
The JPanda 