Uploaded November 2024 | Updated November 2026, 2 days ago
ABSTRACT ๐
Discover how to enhance your Power BI workflow with Tabular Editor and the OpenAI API. This presentation demonstrates how, with a few simple C# scripts, you can directly access the OpenAI API from Tabular Editor to create a custom AI assistant with full access to your Power BI reportโs data modelโincluding tables, columns, relationships, measures, calculation groups, and more. Use this assistant to comment on DAX code, generate model documentation, write measures, and more, harnessing the full power of the latest OpenAI modelsโall without the need for Power BI Premium or Fabric capacity. An OpenAI API subscription is required, and Tabular Editor 3 is necessary.
GUEST BIO (Andrzej Leszkiewicz) ๐ค
Andrzej is a Power BI and data visualization developer and consultant, data explorer, explainer, and visualizer. He creates highly customized, interactive visualizations using the Vega visualization grammar and Deneb. Andrzej has introduced IBCS-styled data visualizations, embedded into Power BI's built-in Table, Matrix, and Card visuals. An IBCSยฎ Certified Analyst, he is a passionate advocate of IBCS standards. With a background as an IT project manager and CIO in non-IT companies, Andrzej has been a full-time independent freelance Excel and VBA developer and consultant since 2011, focusing entirely on Power BI and data visualization since 2020. Through his YouTube channel, LinkedIn, and other social media, Andrzej shares his knowledge and passion for data visualization and related topics.
RELATED CONTENT ๐
Tabular Editor -- docs.tabulareditor.com/index.html?tabs=TE3
Open AI API -- platform.openai.com/docs/overview
Andrzej's Youtube -- youtube.com/@power-of-bi
Andrzej's LinkedIn -- linkedin.com/in/avatorl
Andrzej's Blog -- powerofbi.org
Andrzej's GitHub -- github.com/avatorl
VIDEO CHAPTERS ๐บ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES ๐
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulareditor #te3 #AI #externaltools
ABSTRACT ๐
Discover how to enhance your Power BI workflow with Tabular Editor and the OpenAI API. This presentation demonstrates how, with a few simple C# scripts, you can directly access the OpenAI API from Tabular Editor to create a custom AI assistant with full access to your Power BI reportโs data modelโincluding tables, columns, relationships, measures, calculation groups, and more. Use this assistant to comment on DAX code, generate model documentation, write measures, and more, harnessing the full power of the latest OpenAI modelsโall without the need for Power BI Premium or Fabric capacity. An OpenAI API subscription is required, and Tabular Editor 3 is necessary.
GUEST BIO (Andrzej Leszkiewicz) ๐ค
Andrzej is a Power BI and data visualization developer and consultant, data explorer, explainer, and visualizer. He creates highly customized, interactive visualizations using the Vega visualization grammar and Deneb. Andrzej has introduced IBCS-styled data visualizations, embedded into Power BI's built-in Table, Matrix, and Card visuals. An IBCSยฎ Certified Analyst, he is a passionate advocate of IBCS standards. With a background as an IT project manager and CIO in non-IT companies, Andrzej has been a full-time independent freelance Excel and VBA developer and consultant since 2011, focusing entirely on Power BI and data visualization since 2020. Through his YouTube channel, LinkedIn, and other social media, Andrzej shares his knowledge and passion for data visualization and related topics.
RELATED CONTENT ๐
Tabular Editor -- docs.tabulareditor.com/index.html?tabs=TE3
Open AI API -- platform.openai.com/docs/overview
Andrzej's Youtube -- youtube.com/@power-of-bi
Andrzej's LinkedIn -- linkedin.com/in/avatorl
Andrzej's Blog -- powerofbi.org
Andrzej's GitHub -- github.com/avatorl
VIDEO CHAPTERS ๐บ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES ๐
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=SrqmOLzXguo
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulareditor #te3 #AI #externaltools







![Simplify Power BI DAX with Visual Calculations
If youve ever written a running total in DAX, you know its more work than it has any right to be. CALCULATE, FILTER, a column reference you have to get exactly right, and a quiet prayer that it behaves at the subtotal level. Visual calculations let you write RUNNINGSUM([Sales]) and get on with your day.
Theyre a calculation layer that lives inside the visual itself, working on the data thats already been aggregated rather than querying the whole model. Thats also why theyre often faster, sometimes dramatically so on DirectQuery.
I walk through the core functions (running totals, moving averages, PREVIOUS and NEXT for period comparisons, FIRST, LAST, INDEX, and RANK), then the hierarchy functions like COLLAPSE and EXPAND that make % of parent and % of grand total almost trivial. We also get into AXIS and RESET, which control the direction a calculation runs and where it restarts, because thats the part that quietly breaks peoples running totals across years.
One honest caveat. Yes, theyre easier and faster. But because each one only lives in a single visual, they can fragment your business logic across reports if youre not careful, so I cover when a visual calc is the right call and when it really should be a centralized measure.
RELATED CONTENT ๐
Visual Calculations Guide https://go-ae.org/hc-yt-visual-calc-guide
BECOME A CHANNEL MEMBER ๐
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE ๐
https://havens-consulting.creator-spring.com/
LETS CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
BUSINESS PAGES ๐
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Analytic Endeavors https://go.analyticendeavors.com/86d335734f
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #DAX #DataVisualization #MicrosoftFabric #BusinessIntelligence Simplify Power BI DAX with Visual Calculations](https://i.ytimg.com/vi/VEwGH6i2aeE/mqdefault.jpg)

![Communication is the New Code: Beyond Copy/Paste with GPTs (with Kurt Buhler)
The landscape of Power BI development is rapidly evolving as AI tools transform how we approach data modeling, DAX development, and report creation. While many professionals are familiar with ChatGPT, the ecosystem of AI assistance has expanded dramatically, offering specialized tools that can revolutionize your Power BI workflow.
In this comprehensive session, well explore cutting-edge AI tools that go far beyond basic chatbots:
๐ค Claude Desktop & MCP Servers - Discover how Claudes advanced reasoning capabilities and Model Context Protocol (MCP) servers can provide deeper insights into your data models, suggest optimizations, and help debug complex DAX expressions with unprecedented accuracy.
โก GitHub Copilot for Power BI - Learn how this code completion tool adapts to Power BI development, accelerating DAX writing, M queries, and even documentation generation.
๐ Advanced AI Workflows - See real-world demonstrations of AI-assisted Power BI development, from automated measure generation to intelligent data modeling suggestions.
Well provide an honest assessment of these tools - the goods (incredible productivity gains), the bads (current limitations), and the uglies (potential pitfalls and over-reliance risks). Youll leave with practical strategies to integrate these AI tools into your daily Power BI development process.
Whether youre a seasoned Power BI developer or just getting started, this session will show you how communication truly is the new code in our AI-augmented world.
GUEST BIO (Kurt Buhler)๐ค
Kurt Buhler is a renowned Power BI expert and prolific content creator. Follow his insights and tutorials at [Kurts Blog] and connect with the community using #PowerBI #AITools #DataAnalytics #DAX #PowerPlatform #ArtificialIntelligence #DataModeling #BusinessIntelligence
RELATED CONTENT ๐
Data Goblins https://data-goblins.com/
LETS CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
HAVENS CONSULTING PAGES ๐
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
EMAIL US AT ๐ง
info@havensconsulting.net Communication is the New Code: Beyond Copy/Paste with GPTs (with Kurt Buhler)](https://i.ytimg.com/vi/W3EvSNt2ZWg/mqdefault.jpg)
