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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.