Every day, Every minute, Fresh data from Business Central. Cloud-enabled near real-time data export—Isn’t that the dream?! I recently discovered an amazing open-source extension for Business Central that let us seamlessly synchronize our data to an Azure Data Lake.

I’m often asked about how to transition from Power BI to Synapse—Here’s my simple 7 step guide to do just that.

Quick tip for Synapse Serverless SQL💡 Use the values of wildcards in your SQL query—Very powerful way to convert your file path or filename metadata into actual data!