Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Excel write back connected to Power BI dataset.

Hey, I'm in need to make a form to edit values in excel from powerbi dataset. So that other people could entry the values and it would appear in report 

here is what im doing/trying to do:

  1. PowerBI report dataset input with excel extension

  2. Excel makes pivotable

  3. Need additional column for form, to manually input a forecast

  4. And to take it back to Powerbi report

Is there any possibility to do it without using additional database tool/excel extension? (like Acterys or PoweronBi) 

p.s. for powerapps the dataset is too large (Pbix is connected to sql database) 

 Many thanks!




5 Replies

  • not currently possible without third party tools. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for the reply, maybe there is excel tool that you can suggest? Like acterys, but maybe cheaper? Cause acterys ask around 50$ a month for a user.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        Power BI was fundamentally designed as a one way street. Only a radical design change can help.

        Look for other tools.