Challenge: A client using a proprietary data system lacked a native Power BI connector, forcing them to export via CSVs.
Solution: Built a custom Power Query connector (compliant with Microsoft certification requirements) Secure authentication was included, along with in-connector license checks tied to user permissions.
Outcome: Direct access to live data sources in Power BI Desktop, eliminating manual exports and reducing refresh cycles from hours to minutes.
Tech: Power Query SDK, Azure Function authorization layer
Result: 70 % faster report build time & improved data trust & reusability.