best way to input data to PowerBI

[Red217]

Hello, 

from your experience, what is the best way to get the user to "input data" within the PowerBI enviroment?

is it via "Custom forms" of PowerAutomate and then integrated to a PowerBI report? 

is it just simpler to use a Sharepoint custom form ? 

thanks

[Nathaniel_C]

Hi @Red217 ,

You might use Enter Data, which is in Power Bi and Power Query.  This allows you to enter rows and columns by hand, or you can paste the data into this table.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Red217]

Thanks but i mean more as a platform to enter different data ( at least 100 input fields ), the manual enter data is not relevant in this scenario but thanks for trying to help

[mariussve1]

I think the best way is to make a Power App and embed this into a Power BI report / dashboard. Power Apps can have numeric slider input, text input, boolean and a lot lot more.

If you then embed this in your report ( Power Apps chart ) the end users can give input. If you then in Power Apps make a Power Automate you can store the input with a button in SQL database, excelsheet, csv files or What you feel is best.

Then this can be the source of your report so the input from end users can impact the model.

br

Marius

[Red217]

Thank you, 

i have played with it yesterday, the entire powerapp > Writeback > refresh dataset approach , looks exactly like what i need

[Nathaniel_C · Accepted solution]

Hi @Red217 ,

Thank you! I do not have an answer for you, but you might repost this in Desktop, and slightly change the question to which one is better?

Good luck!

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel