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...
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