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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors