March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to Solution.
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
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 👍
Proud to be a Super User! | |
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
91 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |