Forum Discussion

ahokky's avatar
ahokky
New Member
4 years ago
Solved

Data Input from External Organizations

My organization is serving a client who is a contributor to a collaborative project with 7 other organizations. At least one representative from each institution will need to be able to input new dat...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi ahokky 

     

    Power BI is very good and getting data from multiple sources and consolidating it into a single dataset which you can then create powerful reports on.

     

    For data input Power BI is not the tool for the job in my opnion. Something like Power Apps could do this for you. And you can then use Power BI to consume the data from Power APps.

Alexandra_B's avatar
Alexandra_B
Helper III
4 years ago

Hello ahokky ,

I was wondering if you managed to solve this? I need to do the same and was looking for tips 🙂

For the moment I am just thinking of creating a form using OneDrive (Microsoft forms) , the results are saved automatically and can link the spreadshet to Power BI. I am looking for more options though.
Thank you.

  • ahokky's avatar
    ahokky
    New Member
    4 years ago

    Hi Alexandra,

     

    We inevitably went with using forms in Power Apps to collect data and submit them to a SharePoint list. This SharePoint list is then used as the data source for the Power BI dashboard. You may also be able to use Microsoft Forms for this, as well.

    • Alexandra_B's avatar
      Alexandra_B
      Helper III
      4 years ago

      Great, will try anything.
      Thank you for your reply.

       

      All the best!  🙂