topic Re: best way to input data to PowerBI in Developer

best way to input data to PowerBI

Red217 — Mon, 04 Jul 2022 13:50:22 GMT

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

Re: best way to input data to PowerBI

Nathaniel_C — Mon, 04 Jul 2022 17:18:47 GMT

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

Re: best way to input data to PowerBI

Red217 — Mon, 04 Jul 2022 17:20:19 GMT

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

Re: best way to input data to PowerBI

Nathaniel_C — Mon, 04 Jul 2022 17:23:32 GMT

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

Re: best way to input data to PowerBI

mariussve1 — Tue, 05 Jul 2022 17:00:40 GMT

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.

Marius

Re: best way to input data to PowerBI

Red217 — Tue, 05 Jul 2022 17:11:58 GMT

Thank you,

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