Saurabh Jain Posted February 16, 2023 Share Posted February 16, 2023 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.