Talking to Copilot about Power BI Calculated Columns and Measures

I had a conversation with Copilot about how to create and use calculated columns and measures in Power BI. I recently had a discussion about this because I learned that when I use a LakeHouse table from Power BI, I can only create measures, but not calculated columns. Copilot did a great job explaining details … Continue reading Talking to Copilot about Power BI Calculated Columns and Measures →

SharePoint on MGDC FAQ: How do I process Deltas?

IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. This is a follow up on the two blogs about delta datasets. If you haven't read them yet, take a look: SharePoint on … Continue reading SharePoint on MGDC FAQ: How do I process Deltas? →

Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC)

IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. I was considering if ChatGPT could help me write SQL code to merge a SharePoint Delta State Dataset, like the ones we are … Continue reading Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC) →

Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies

This post mixes the spirit of Halloween and the passion for SQL Server 🙂 Have you noticed how SQL Server has a number of things that seem right out of a horror movie? As a test of your SQL Server expertise and for a fun Halloween trivia game, try to describe the items in … Continue reading Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies →