When data is every where
I'm trying to pull data from multiple sources into a dashboard but not all of the data has connectors for PBI. My gut reaction is to just pull it all into an Excel sheet but that's a bit of manual labor for up keep (unless I script it and run a GitHub action). Would a lake house setup be more ideal? I feel like I'm missing something.
Note: I work for a large corporation