Forum Discussion
Post ProdigyAppend Data
Hey stribor45 ,
you can't because this is how it works. You can consider using incremental refresh, even if API-based data sources are not supporting incremental by default. Start reading everything GilbertQ wrote about incremental refresh: https://www.fourmoo.com/2020/07/01/how-to-configure-incremental-refresh-with-power-query-in-power-bi/
Hopefully, this provides enough to get you started.
Regards,
Tom
Super UserHey stribor45,
Power BI Service sets the values of both parameters RangeStart and RangeEnd when the Service initiates refresh. Because APIs do not support query folding filtering must happen immediately. Please be aware that the incremental refresh happens on the Service.
Hopefully, this explains the filter step.I recommend reading this article: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Maybe you also want to split the pbix into a data pbix and a content pbix. The data pbix defines the dataset and holds the incremental refresh definition. The content pbix contains the data visualizations, but instead of connecting to the API this pbix connects to the Power BI dataset that becomes available after the data pbix was published to the Power BI Service.
Regards,
Tom