Forum Discussion

Dayna's avatar
Dayna
Helper V
4 years ago

Incremental refresh causing duplicate rows

Hello,   I've implemented incremental refreshes on one of our fact tables, called 'Transactions'.   I can see on a given day there's been a change to some rows, and when this dataflow is consumed...
Need Help
Jeanxyz's avatar
Jeanxyz
Power Participant
3 years ago

I read the documentations, indeed I need to enable 'get the latest data with direct query' in refresh setup page. This is not practical because 1) I will need to update my PB license to a premium per user one and the same for all users who need access to the Power BI report on service, 2) I need to change the storage mode of relevant tables into 'direct query' mode, this also means I need to rewrite all the DAX measures from scratch. 

 

I'm wondering if there is any other solution. My only need is to shorten the data refreshing cycle from 25 minutes to 5-10 minutes. I'm connecting Power BI to Jira data using a odata connector. 

lbendlin's avatar
lbendlin
Super User
3 years ago

Your data source is not compatible with Microsoft's implementation of Incremental refresh.  Run a process outside of Power BI (for example on SQL Server) that can properly handle data updates. You can then connect to that SQL server in Direct Query mode for close to real time performance.