Can users enter data?

[Anonymous]

Hi

I have a dashboard with financial data including actual costs versus budgeted costs. I would like to have a 'forecast' type column to project the full year forecast but I would like that to be an input field by the user that saves to an excel file. In other words the user is writing to an excel file through PowerBI. 

Is this possible? 

[v-diye-msft]

Hi @Anonymous 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

[amitchandak]

@Anonymous , refer to this. Done using google sheet and One drive excel

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Write-Back-From-BI/m-p/1044976#M16

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

[FarhanAhmed]

You can look into the Alteryx Visualization for this

https://www.alteryx.com/partners/technology-partners/microsoft

https://powerbi.microsoft.com/en-us/blog/the-alteryx-starter-kit-for-microsoft/

Or you can create a Power App to Enter/Edit separately Forecast and then use this Power App visualization to have a Input form in Dashboard/Report.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual