Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incremental load without Incremental Refresh

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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