Incremental load without Incremental Refresh

[Anonymous]

Hi All,

As I am using Stored Procedure to fetch the data from Sql Server to Power BI I am not able to use Incremental Refresh option.

Do we have an option in M query of Power BI to insert new row if row doesn't exist and update the row if it has been modified in the source and has to avoid insertig duplicate values.

Thanks

Vannikannan K

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Currently, you can't directly change table records to automatically append new rows/change old row values based on current table records.

For these steps, I'd like to suggest you add t-sql query to check and modify the query results.

Regards,

Xiaoxin Sheng

[ibarrau]

Hi. Please be sure to have the last power bi desktop version and follow this steps.

https://www.youtube.com/watch?v=BQahH53ayKU

Hope this helps,