Forum Discussion
Athlete Report Management System using Power BI
Hi big_ozzie ,
For the data exported by different devices, I suggest that sports coaches merge them into a .csv file and upload it to OneDrive for Business, and then you only need to import this .csv file into Power BI Desktop.
This is the easiest way to import and export.
Of course, a more ideal solution is for the coach to import the collected data into the cloud database, but this will increase the difficulty of the coach's work.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Assuming that all of these devices use different formats for their CSV you will want to look at some loosely structured data storage (ironically Power BI Dataflows actually fall into that category as well) rather than a database storage solution. Think of it from the perspective of the coaches, and create a solution that is the least burdensome for them (plus, you MUST find a value add for the coaches else they will not be interested in collecting the data reliably)
Power BI itself has no problem to ingest these files and combine them in a meaningful way. Make sure the file names (or the file contents) contain enough information to identify the department, device, and date.