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.
Bear with me, I have the most basic understanding of this. So right, one goal is to create something which burdens coaches the least. I feel that the least burdensome solution would be one that only requires coaches to export their device's data, import it somewhere, and be done. Anything else is handled and reports are populated in Power BI. Coaches could do this at any frequency, updating the storage file with Power BI following suit. For example, OneDrive file storage was actually initially considered as a simple solution. A coach uploads their data to a file stored on OneDrive that is tied to Power BI. I guess this would be considered "loosely structured data storage."
I looked at Power BI Dataflows. What do you think is the best way to create a new dataflow for this purpose?