Forum Discussion

emma313823's avatar
emma313823
Helper V
2 years ago

help in most efficient approach

All,

 

I have an excel file connected to my power bi model and I'm wondering if someone could offer a best practice or most efficient and secure way to approach the connection to the model.

 

The Excel file contains forecasting numbers which can be updated by the owners of the company at any time. I don't want the file messed up by somone doing something they should not, however I want to reduce my having to manually do the entry. I want to allow them to update previous forecast numbers, enter new ones, but still maintain a level of security that prevents them from deleting etc.

 

This may not be the right forum, but thought I would start here.

 

Emma 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Look into using the Power Platform to write an app.