Forum Discussion

deez0r's avatar
deez0r
New Member
5 years ago
Solved

Where to store data?

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.

Data Protection
Dataflow
  • ibarrau's avatar
    ibarrau
    5 years ago

    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,

2 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    5 years ago

    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,

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.