Forum Discussion
Solved
Transfer Query result in data table. Update or Create new row based on the primary key
Hi, I'm using a odata service to load the latest changes from a table based on the SQL Timestamp. We want to avoid that the query is loading each night millions of records. So the result of my Que...
Hi louagej,
Maybe you can try to use 'Table.InsertRows' function to add custom row.
Regards,
Xiaoxin Sheng
Dear Xiaoxin Sheng,
Maybe my explanation was'nt very clear but I don't want to add an extra column.
I just need to insert a new row in case the primary key is new or update the row when it already exist.
All colums are already in the table.
I read on Power BI forum that it might be better to use direct query when we're dealing with large datasets.
Maybe I'm trying to use Power BI for something that it wasn't designed for.
Kind regards,
Job
Hi louagej,
Maybe you can try to use 'Table.InsertRows' function to add custom row.
Regards,
Xiaoxin Sheng