Forum Discussion
Incremental refresh for Custom data connector. Store custom data.
Hi RandomPBIUser ,
This may require a manual way to get the maximum transaction number in time after the last refresh and store it somewhere (like an excel file) and then connect to that excel file in Power BI Desktop also for your report. Create the parameters and take the values from the query associated with the excel file. You can refer to the video below to do this.
Store max transaction number in excel file
Populate a Power BI parameter list using a query
Finally, try to do some configuration in the custom connector: add a filter (like: transaction number>[parameter value]) ....
Power BI Data Connector manual
Best Regards
I need to store last committed transaction number somewhere and use that in the next refresh. This would avoid fetching old data I already have.
Hi RandomPBIUser ,
This may require a manual way to get the maximum transaction number in time after the last refresh and store it somewhere (like an excel file) and then connect to that excel file in Power BI Desktop also for your report. Create the parameters and take the values from the query associated with the excel file. You can refer to the video below to do this.
Store max transaction number in excel file
Populate a Power BI parameter list using a query
Finally, try to do some configuration in the custom connector: add a filter (like: transaction number>[parameter value]) ....
Power BI Data Connector manual
Best Regards