Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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,
Happy to help!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |