Designing effective Power BI reports isn't just about data accuracy—it’s also about creating a visually clean, user-friendly experience. When it comes to color, less is often more. This article will guide you through the benefits of using a single color or a few complementary shades in Power BI, highlighting how this minimalist approach can improve readability, reduce cognitive load, and help users focus on insights instead of aesthetics.

In this guide, we’ll cover how to bring task data from Microsoft Planner into Power BI for analysis, using Power Automate and SharePoint as intermediaries. Since Power BI currently lacks a direct Planner connector, Power Automate lets us fetch the data from Planner and save it to SharePoint as a JSON file, enabling Power BI to access it on a scheduled basis.

There are various scenarios where Power BI requires a gateway to refresh our information. Sometimes it's necessary and makes sense, but other times it can be frustrating.

There may be more scenarios than the ones I will mention, but typically when scraping a website (using the Web.Pages function in Power Query), a gateway is required. You might have a complex operation that you consider solving with Python within Power BI, but that also requires a gateway.

This article will show how we can use Azure Functions to perform a simple operation with Python and then read it from Power BI as a simple API GET request.