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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
AndreaLee1212
Helper I
Helper I

Reduce the size of the data that enters Power BI

Hi everyone,

 

I have a customer using PostGres Sql with Direct Query and have historical data that they don't need, and it's affecting PBI performance.

The customer just want to bring to the PBI the data that on collumn Status is : " Completed".

 

Are any of the bellow options correct to do this without compromise the performance or from the all options available according to your experience witch one is the best for this situation: 

Option 1 -using dynamically M query parameters to send a query to the DB and exclude "Completed"

Option 2 - to use dataflows and apply a filter to only apply results for status="Completed"

Option 3 - using the Advanced Editor in Power Query Editor and push only results for status="Completed"

 

Thanks in advance.

1 ACCEPTED SOLUTION
ichavarria
Solution Specialist
Solution Specialist

Hi @AndreaLee1212,

 

The recommended option would be: https://learn.microsoft.com/en-us/power-query/connectors/postgresql#connect-using-advanced-options. Which is basically write a native SQL Query that will filter the data for only those with status completed. This will have the best performance as Power BI will only bring what is queried and speed up performance. In Power BI you should always try to avoid bringing data that you do not need. 

 

 

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

View solution in original post

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @AndreaLee1212 ,

 

You could implement incremental refresh https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




ichavarria
Solution Specialist
Solution Specialist

Hi @AndreaLee1212,

 

The recommended option would be: https://learn.microsoft.com/en-us/power-query/connectors/postgresql#connect-using-advanced-options. Which is basically write a native SQL Query that will filter the data for only those with status completed. This will have the best performance as Power BI will only bring what is queried and speed up performance. In Power BI you should always try to avoid bringing data that you do not need. 

 

 

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.