Where to store data?

[deez0r]

I am going to be building out quite a bit of visualisations for my team. However we are pulling this info from mutliple spreadsheets and API calls (converted into CSV). We do not want to store these on a local desktop as if someone is off this wont be updated. Can someone let me know a save and secure place that we could potentially store this information?

A lot of this data could be sensitive. We were thinking about utilsing an s3 bucket in AWS but it seems very difficult to connect to. Any help would be appreciated.

[v-lionel-msft]

Hi @deez0r ,

You can save the data in SharePoint Online or OneDrive for Business, I think you have many choices.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau · Accepted solution]

Hi, you can store it in azure data lake gen2. You would connect easily to that source with Power Bi. With data lake you will be able to store the data with azure funcions or data factory keeping all orchestration and scripts in cloud. If you want S3, you will need to get that data using Athena with ODBC.

Regards,