Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
is there a way I can apply a query before I pull the data from the data flow created?
I have an Azure table with every second new row updated and which is built in dataflow as now but while refresh it takes 10m - 15m and I want to increase the performance. can I apply a query before pull in my data like we do in APIs?
I want to apply date created within 4 months.
Solved! Go to Solution.
Hi @Anonymous ,
If you want to refresh only the most recent months, maybe you can try manually adding a filter to the power query to filter the last four months and then recopy the whole query into dataflow. This is the easiest way to do it.
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but as you mentioned it's only with a premium license.
Hi @Anonymous ,
If you want to refresh only the most recent months, maybe you can try manually adding a filter to the power query to filter the last four months and then recopy the whole query into dataflow. This is the easiest way to do it.
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to your description, you can use incremental refresh for the data flow.
Incremental refresh, which provides the following benefits for dataflows:
When using incremental refresh, the Power BI service dynamically partitions the data and separates the data that needs to be refreshed frequently from the data that is refreshed infrequently. In each subsequent refresh, the query will filter and return only those records within the refresh period dynamically defined by the parameters.
Because less data needs to be refreshed, the overall use of memory and other resources in Power BI and the data source system is reduced.
Incremental refresh is available in dataflows created in Power BI and dataflows created in Power Apps.
Using incremental refresh in dataflows created in Power BI requires that the dataflow reside in a workspace in Premium capacity. You need to have a Power BI Premium or Power BI Premium Per User license.
For more information,Please see: Using incremental refresh with dataflows
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
35 | |
30 | |
15 | |
12 |