Forum Discussion
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 ...
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,
ibarrau
Super User
Super UserHi, 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,