write back to multiple sources

[Anonymous]

Hi,

I have the following visual on the report which has SQL data source:

Broker	Stock No.	Year	Forecast Sales
AAA	123	2020	$2000 (Editable)
BBB	423	2021	$1500 (Editable)
CCC	523	2020	$1000 (Editable)

 The requirement is: the end user should be able to enter the values in Forecast Sales column. Is it possible to write back data to two different data sources SQL and Excel? Also can it be reflected on the report immidiately?

Please suggest how to achieve this.

Thanks

[amitchandak · Accepted solution]

@Anonymous , You need to use the power app

https://www.youtube.com/watch?v=LxuRzj0X348

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Wri...

[Anonymous]

hi @amitchandak ,

Is it possible to write back from Power Apps to two different sources : SQL and Excel?

Thanks