I'm trying to understand the main difference between connecting power BI to azure datalake vs connecting to a sharepoint folder structure?
My company is about to start using power BI for analytics purpose, and we are currently looking into possible ways to store our data. At an old company we just built our own "data lake" in sharepoint using a folder structure and connecting power BI to the folder or file needed. The files in our "sharepoint data lake" were update automatically so everything worked smooth.
Now i just would like to know the difference between connecting to azure data lake vs my home made sharepoint data lake. Worth nothing is that we don't have a huge amount of data.