Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |