How do you bring Excel Sources to your DWH?

[Saurabh Jain]

The ideal world 🌈: all your data sources are in your Datawarehouse.

(As much up stream as possible)

Reality is, users often need a way to give manual input.

That can be for:

• + Budgeting/Forecasting
• + Making adjustments to reporting logic
• + Giving in parameters for customers
• + Indicating Exceptions

Importing these sources in Power BI (connecting to a network drive) is often undesired
-> your logic now needs to happen in #Powerquery.

📌Question: What's your process to easily get manual sources into your Datawarehouse? (Excel, Sharepoint lists, CSV etc)
P.S. Not all customers have a dedicated BI team with the knowledge there. I'm interested in both simple and advanced solutions.