Forum Discussion

Red217's avatar
Red217
Icon for Helper III rankHelper III
4 years ago
Solved

best way to input data to PowerBI

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 repor...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    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

mariussve1's avatar
mariussve1
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
Red217
Icon for Helper III rankHelper III
4 years ago

Thank you, 

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