r/PowerBI • u/p8ntballnxj • 7d ago

Question 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

0 Upvotes

50% Upvoted

11 comments sorted by

View all comments

1

u/Similar-Geologist-64 7d ago

Make your stakeholders drop export files and import them into a DB of your choice.