Forum Discussion
Data Input from External Organizations
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.
Power BI is a visualization service, not a data collection service. That said, as long as you can find a location to consolidate your data, google drive or even externally shared/collaborated excel file that is hosted in the tenant the same as your Power BI tenant, and your clients have access to it, you can connect using Power BI to that Excel file.
Once that is done, you can definitely share your reports to external users using power bi.
Summary: Consolidate data somewhere else, then use power bi to connect to it.
Another option this. Each client have their own eg excel file in their tenant. And you just need credential to access that excel file. This will allow you to connect to different excel files from different clients in Power BI.
This requires the client organization to enable collaboration with external users, i.e giving file access to you.