Want to use Claude in your apps and flows in Power Platform? Fortunately, Microsoft allows you to create your own custom connectors, and it’s fairly quick to do. This same process will work for other LLMs (e.g. Azure OpenAI), too, with just a few tweaks. When you create custom connector, put some thought into how… Continue reading: How to create a custom connector for Claude.ai in Microsoft 365
Every time I use a date table in a new Power BI model (so… every time), I have to specify sort order for text columns – e.g. to sort January and February text fields by their month start instead of alphabetically. This is something AI can do for us in bulk with TMDL! All we… Continue reading: Sort and format your date table with TMDL and AI!
Can AI write DAX measures? YES! The missing link for this for the longest time has been the the lack of visibility for information about the model. But, with the advent of TMDL, we can now give AI enough context about the model to let it successfully create DAX measures in Power BI. The “trick”… Continue reading: Using AI and TMDL to Create Power BI Measures
With the advent of TMDL, we’re able to use AI to update our DAX measures to add descriptions and inline comments to our code (this links to the video walkthrough)! Here are the prompts we used to do this as well as test results with different LLM models. Prompt 1 – Add Descriptions to Measures… Continue reading: Using AI to Add Measure Descriptions & //Comments to DAX
Plan Designer is currently in public preview in Power Platform. It promises to create an almost-full solution for almost-any business problem! The use case I’m trying it out on is to create a dispute management system, we’ll see how it does. What I may do here over time is come back and re-prompt every few… Continue reading: Power Apps Plan Designer: A Review
Creating tasks in a system that allows interaction with said tasks (e.g. checking a box to complete) can be really tedious and time-consuming – this makes it a perfect target for AI automation! My issue is that most of the AI tools designed for this across all the systems I’ve tried are currently half-baked, meaning… Continue reading: Using AI to Create Tasks