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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors