Categorised data in PowerBi

0 votes

I'd like some advice on how to categorize/group data in PowerBi.

For example, I set up a conditional column in Power Query to achieve the results seen in the "Group" column by saying if ID is 8304, then Group B, and if ID is 8660, then Group F — but the database is large, and I'm already experiencing performance issues when trying to set up a report based on individual Groups; the data takes a long time to load.

Is there a better or more efficient way to group data?

ID Group
8015 A
8020 A
8229 A
8304 B
8389 B
8391 C
8414 D
8421 A
8469 A
8572 A
8619 F
8660 F
8663 J
9102 A
9104 K
Apr 26, 2022 in Power BI by Neha
• 9,060 points

1 answer to this question.

0 votes

If you're experiencing performance issues when setting up a report based on individual groups in Power BI, there are a few alternative approaches you can try to improve efficiency:

  1. Grouping in Power Query: Instead of using conditional columns in Power Query, you can use the Group By transformation to create a separate table with grouped data. This way, Power BI will load the pre-grouped data directly, which can improve performance. You can then establish relationships between the original table and the grouped table for reporting purposes.

  2. Creating a calculated column: Instead of using conditional columns, you can create a calculated column in the Power BI data model to assign groups based on specific conditions. This way, the grouping is done within the data model, and the report will load faster since the grouping is already performed during data refresh.

  3. Using DAX measures: If the performance issue persists even after trying the above methods, you can consider using DAX measures to dynamically calculate groupings during visualization rather than pre-calculating them. This can help improve performance by reducing the data size and calculations done during data refresh.

  4. Utilizing query folding: Ensure that query folding is happening in Power Query to push the grouping operations to the underlying data source. This way, the database performs the grouping, and only the grouped results are loaded into Power BI. Check that your data source supports query folding and optimize your Power Query steps accordingly.

It's also worth considering optimizing the overall performance of your Power BI report by evaluating other factors such as data volume, data model complexity, and visualizations. Additionally, ensuring your data sources are properly indexed and optimized can significantly impact performance.

By employing these techniques, you should be able to enhance the performance of your Power BI report when grouping data.

Preparing for the Power BI exam? Check out Power BI Course Content now! 

answered Jun 20, 2023 by anonymous
• 1,380 points

Related Questions In Power BI

0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

answered Oct 22, 2020 in Power BI by anonymous
• 65,910 points
0 votes
1 answer

R scripts for Importing Data in powerBI?

There may be times when you don’t ...READ MORE

answered Nov 11, 2020 in Power BI by Gitika
• 65,910 points
0 votes
1 answer

Categorised data in Power BI

Use a helper table to store these ...READ MORE

answered Feb 8, 2022 in Power BI by CoolCoder
• 4,400 points
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
0 votes
1 answer

Which one should I choose Tableau or Power BI?

Hi Grim, Both the BI tools - Tableau ...READ MORE

answered Apr 6, 2018 in Tableau by ghost
• 1,790 points
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 8,620 points
0 votes
1 answer

DAX : Occurrences of "count"

Try this for creating a calculated column ...READ MORE

answered Nov 22, 2018 in Power BI by Upasana
• 8,620 points
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
0 votes
1 answer

Calculate average speed in Powerbi using DAX

To calculate the average speed for automobiles ...READ MORE

answered Jun 20, 2023 in Power BI by Neelam
• 1,380 points
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,380 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP