Kyle HalePower BI Modeling: Adventures with VARs and Conditional DAX in DirectQuery ModeRecently while helping a customer convert an Azure Analysis Services model into a Power BI Premium composite model backed by Databricks…Aug 312Aug 312
Kyle HaleThe 5 Key Differences Between Databricks Genie and Power BI CopilotWhile showcasing Databricks Genie, our new text-to-SQL “ask your data” product, I said it offered a different use case that could reduce…Jul 151Jul 151
Kyle Hale7 Techniques of Semantic Modeling for Databricks GenieA key application for GenAI that has spared a lot of interest is text to SQL (or “text2SQL”) chatbots: an interface where a user can come…Jul 21Jul 21
Kyle HaleApplying Dynamic Tags To Databricks Job Clusters in Azure Data FactoryA few customers have asked me, “When running a Databricks notebook activity in Azure Data Factory, how do I set tags dynamically on the job…May 17May 17
Kyle HaleTutorial: Connecting Databricks’ DBRX LLM to a Power BI reportThe semantic lakehouse of Power BI combined with Databricks SQL already provide great visual analysis for thousands of customers, but in…Apr 162Apr 162
Kyle HaleStep by Step: Connecting to Databricks SQL in Microsoft Power AppsMicrosoft’s PowerApps is a low code business application development platform designed to be friendly for power users who:Mar 223Mar 223
Kyle HalePassing Multi-Valued Parameters from Power BI Paginated Reports to Databricks SQLQuite a niche topic, but it’s come up a couple of times so I thought I’d share the solution here on the blog.Mar 3Mar 3
Kyle HaleCreating Delta Lake Tables in Databricks Unity Catalog with Azure Data FactoryScenario: You have an Azure Data Factory pipeline that produces a Delta Lake table in cloud storage. You want to make this table available…Jan 273Jan 273
Kyle HaleThe Bridge to Nowhere: Self-Service BI in an LLM WorldHopefully it’s quickly becoming obvious — at least to BI and analytics leaders and practitioners in the enterprise — that LLMs and AI…Dec 11, 2023Dec 11, 2023
Kyle HaleVARCHAR and CHAR in Databricks and Delta LakeDoes Databricks support VARCHAR or CHAR data types?Dec 1, 20234Dec 1, 20234