Insert data from SQL temporary table into Power BI table

[sakamotothais]

 Hello Guys,

Please see if you can help.

I have in Power BI a table called TableAD, where I have the following information.

I have anoter table directly connected to SQL Server called TemporaryAD, where I have a query that picks information only

from today's date and generates temporary table.

I need to know if it is possible, when generating in the TemporaryAD table the data, take this data from today's date and

insert as new records in my physical table of power BI TableAD.

And that this happens automatically later with the gateway and automatic update. 

It's possible?

Thanks

[v-sihou-msft]

@sakamotothais

You can use R scirpt to insert the records into existing SQL table. Please refer to links below:

Use R to export data from Power BI

How to quickly export data from R to SQL Server

Regards,