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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Centropaginaswe
New Member

I need filter 40.000 records

Good afternoon. Please i need filter 40000 records and produce a table of 10000 records which are the result to apply the filter. I want to know if it is better power Automate or Power Bi to perform it? Really thanks

2 REPLIES 2
ichavarria
Solution Specialist
Solution Specialist

Hi @Centropaginaswe,

 

To filter 40,000 records and produce a table of 10,000 records, both Power Automate and Power BI can be used, but the choice depends on the specific requirements of your project.

 

Power Automate (formerly Microsoft Flow) is a cloud-based service that allows you to create workflows to automate repetitive tasks and business processes. If you need to automate the filtering process and save the filtered data to a data source, Power Automate can be a good choice. For example, you can use Power Automate to create a workflow that retrieves the data from a data source, applies the filter criteria, and saves the filtered data to a SharePoint list or a SQL Server database.

 

On the other hand, Power BI is a business analytics service that allows you to create interactive reports and dashboards. If you need to analyze the filtered data and create a visual representation of the data, Power BI can be a good choice. For example, you can use Power BI to import the filtered data from a data source, create visualizations such as charts and tables, and share the reports and dashboards with your team.

 

In summary, if you need to automate the filtering process and save the filtered data to a data source, Power Automate can be a good choice. If you need to analyze the filtered data and create visualizations, Power BI can be a good choice. However, both tools can be used for both purposes, and the final choice depends on the specific requirements of your project and your familiarity with each tool.

 

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly

  • Really thanks. I am going to prove it. If i have another question i will come back here. You are very kind

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!