Posts filed under External Tools

(Livestream Replay) AI Assistant for Tabular Editor - Andrzej Leszkiewicz

DESCRIPTION 📄

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
Open AI API
Andrzej's Youtube
Andrzej's LinkedIn
Andrzej's Blog
Andrzej's GitHub

Posted on November 15, 2024 and filed under Livestreams, External Tools, Data Modeling.

(Livestream Replay) Semantic modeling in VS Code? Introducing the TMDL Extension - Sid Vemuri

DESCRIPTION 📄

In this video, we’re diving into the power of Tabular Model Definition Language (TMDL) and showing you how it can level up your data modeling and development workflow. TMDL is a valuable tool for anyone working with semantic models, and we’ll start by discussing what it is and why it’s worth incorporating into your process.

We’ll then explore the VS Code extension for TMDL, including the motivation behind its creation and the suite of features it offers. From a streamlined editing experience to source control capabilities, this extension brings a lot to the table. In a live demo, we’ll edit a semantic model together, highlighting essential aspects like setting up a smooth development workflow with workspace Git Integration, leveraging the rich editing features, and using the built-in source control in VS Code for version control and collaboration. We’ll even explore how GitHub Copilot can boost productivity with some practical use cases.

Finally, we’ll wrap up with a Q&A session to answer your questions live, helping you make the most out of TMDL and VS Code. Ready to see it all in action? Watch along as we build a semantic model from the ground up and showcase the latest tools and best practices to optimize your development experience.

GUEST BIO 👤

Sid Vemuri is a Technical Program Manager at Power BI that is focused on building features for Power BI Developers. He received his master’s in computer science with a specialization in machine learning from Georgia Tech in 2023 and has dived into all things data including data science, data visualization, data modeling, and, of course, business intelligence. In his free time, Sid enjoys adventure travel, training in mixed martial arts, outdoor activities, and board games.

RELATED CONTENT 🔗

TMDL Extension on VS Marketplace
Tabular Model Definition Language (TMDL) | Microsoft Learn
Power BI Desktop developer mode documentation - Power BI | Microsoft Learn
Siddhartha (Sid) Vemuri | LinkedIn

Posted on November 8, 2024 and filed under Livestreams, External Tools, Data Modeling.

(Livestream Replay) Managing Power BI, to Prepare for Fabric - with Alex Whittles

DESCRIPTION 📄

Power BI is in place in almost all organizations, with varying degrees of effectiveness in its implementation. The introduction of Fabric introduces a transformative shift, amplifying both the opportunities and complexities associated with Power BI. Consequently, it becomes imperative to proactively manage your Power BI ecosystem, focusing on key aspects such as structure, security, processes, and monitoring. This not only establishes a solid foundation for Power BI governance, but also paves the way for migrating your data engineering workloads into Fabric, while retaining full control, transparency, and governance over your data environment.

GUEST BIO 👤

Alex is a 9 year Data Platform MVP, and is the owner and principle consultant at Purple Frog Systems, a Microsoft Data Analytics consultancy in the UK with multinational clients in a variety of sectors. He specialises in the architecture and design of all aspects of data warehousing, ETL, cubes, Power BI and Machine Learning. He’s also the creator of Power BI Sentinel. Alex is on the organizing committee for the SQL Bits conference, and is a regular speaker at many data events around the world including SQL Bits, Data Relay, SQL Saturdays, Data Grillen, 24 HOP and the PASS Summit, and has a Masters degree in Business Intelligence.

RELATED CONTENT 🔗

LinkedIn
Purple Frog Website
Power BI Sentinel Website

Five Tabular Editor 3 Hidden Tips for Power BI!

Video by: Reid Havens &

Join Morten Lønskov and I as he shows us five fantastic hidden gems/tips of Tabular Editor 3. Plus learn about the great (and FREE) course offered by the Tabular Editor team. Tune in to learn more!

GUEST BIO (Morten Lønskov) 👤

Morten is a Product Manager at Tabular Editor where he is focused on ensuring semantic model developers work more efficiently and effectively. He has previously experienced all aspects of creating data solutions as a consultant and in-house data architect with a special enthusiasm for enabling data teams to reach their outcomes through DevOps development practices and collaboration.

RELATED CONTENT 🔗

Tabular Editor Learn
Morton's LinkedIn

Posted on March 5, 2024 and filed under External Tools.