Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Find articles, guides, information and community news

Most Recent
mike_honey
Memorable Member
Memorable Member

I've created a python notebook that helps to automate review and testing of Power BI reports. It embeds a report and then works through every (visible) page and exports the data from every (visible and exportable) visual.

Read more...

Ilgar_Zarbali
Most Valuable Professional
Most Valuable Professional

In this newsletter, we’ll dive into hierarchical directories and how they’re used in analytics. Let's clarify what we mean.

Downloadable Materials 

Read more...

SamWiseOwl
Community Champion
Community Champion

Power BI can connect to, transform and visualise data. Which is great but how do we get that modified data out?

One way is using a Power Automate flow to connect to the published Power BI dataset.

Read more...

Poweraegg
Advocate III
Advocate III

In this video we discuss how to manage a notebook PySpark code throughout the deployment pipeline stages, so that it adjusts dynamically to each deployment stage without needing manual interaction.

Read more...

thartleylogan
Microsoft Employee
Microsoft Employee

Join us at FabCon, March 31 – April, 2025, in Las Vegas! Register today to get the early bird discount. 

Read more...

tharunkumarRTK
Super User
Super User
hackcrr
Super User
Super User

It's a great external tool to generate developer documentation for our reports with a single click, and we want to have a report or document that documents the entire process from data import to Power BI, and from Power BI report authoring to delivery.

In the process, we'll have a lot of pages, measures, parameters, calculation groups, even Power Query queries, and so on. Sometimes we need something to be able to visually observe it and count this information, so the tool shared today will be able to help you!

 

Read more...

Kaviraj11
Super User
Super User

Custom Sorting with Power BI

Custom sorting in Power BI can significantly enhance the clarity and impact of your data visualizations. However, users often encounter several challenges when setting up custom sorts. Here’s a look at some of the common hurdles and how to overcome them:

 

Step 1

Create a Custom Table with all the category either manually in Power Query or read from source.

Create a new column beside and provide the number in the order you want to arrange.

Kaviraj11_0-1731095696156.png

 

Step 2

Create a relationship between the column in actual table to the custom sort table.

 

Step 3

Create a column in Actual table with an expression.

Sort order = RELATED(CustomSortTable[Sort])

 

Step 4

Select the column you want to sort, and a “Column Tools” menu bar will appear at the top. Now Select the “Sort by column” and select the sort order column.

Kaviraj11_1-1731095839638.png

 

Read more...

anmolmalviya05
Solution Sage
Solution Sage

In this blog, we'll explore how to display the previous 6 months of data based on a single slicer selection in Power BI.

Read more...

Poweraegg
Advocate III
Advocate III

Learn how to design a medallion architecure in Fabric!

 

thumbnail.jpgPicture2.jpgPicture3.jpgPicture4.jpg

Read more...

Kedar_Pande
Resident Rockstar
Resident Rockstar

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.

Read more...

anmolmalviya05
Solution Sage
Solution Sage

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.

Read more...

ibarrau
Super User
Super User

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.

Read more...

Migasuke
Super User
Super User

Have you ever worked in Power Query editor and you had to create lot of "helping" queries to achieve your goal? Usually you started to have lot of queries with similar names and majority are just disabled for loading?

Well actually there is an old trick, where you don't need to do that (in majority of cases) and you can just do "self reference" your existing query.

 

Migasuke_0-1729872633486.png

 

 

 

 

 

 

Read more...

zenisekd
Super User
Super User

Have you ever wished you could schedule an automatic snapshot of calculated data from Power BI and then build a report on top of it? 

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.