Microsoft Fabric Lakehouse OneLake security, some experiences

Today was a very interesting day at a customer's site, where I had some trouble determining why the OneLake security wasn't functioning as I expected. Spoiler alert: a part was me, and a part had to do with setting up my testing account. Setup The reason I got myself into this little pickle was quite … Continue reading Microsoft Fabric Lakehouse OneLake security, some experiences

DP-700 Training: Choose an appropriate data store

The best place to store your data is in a SQL Server database that no living being can ever access. The end. No, I'm kidding, of course. But there's an atom of truth in this joke. Because for years we, in the structured data industry, have always been convinced that a database is the best … Continue reading DP-700 Training: Choose an appropriate data store

DP-700 Exam training: Configure OneLake workspace settings

OneLake, the OneDrive for all your data, the One Lake to rule them all or however you've heard it being described. Whatever you've heard, OneLake is the single storage on your tenant used to store all the data of your Fabric Capacities. About OneLake The core point to remember is that your tenant has just … Continue reading DP-700 Exam training: Configure OneLake workspace settings

Getting on-premises data into Microsoft Fabric using the data gateway

In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from … Continue reading Getting on-premises data into Microsoft Fabric using the data gateway