Refresh and insert in another database


I working on a project that requires to read the latest closing stock price daily and refresh it on the dashboard, but I need to insert the new daily prices into another database for another system for VAR calculation. Can Power BI automate this? And how can I do a query and some transformation then insert into another database? Thanks

Dear Jonatong,

Power BI has connectors with lot of databases, you can connect and refresh.

Alternatively ( in case connector is not available). You can keep an Excel table and past your data regularly in excel and refresh in power BI.

Hi @jonatong. There was another thread on the forum recently that might have some insights for you … Save a measure's result as a static number. Hope it helps. Greg

Thanks @Greg, I will have a look

Hi @jonatong, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!