Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Are you struggling to get past certain limitations while working with Direct Query in Power BI? Today, I want to share a few quick tips to help you go beyond these limitations and maximize your proficiency in this tool.
So, let’s get started.
Tip 1: Common Table Expressions are not generally supported when working with Direct Query in Power BI. A quick workaround for this would be to re-write your query by including a sub-query.
Tip 2: DAX is available, but there are certain time intelligence DAX features that you cannot use such as every year, month over month, same period, and last year.
Tip 3: Unlike Direct Query, import mode allows you to access basic transformations. For example, duplicating and changing columns in your data set, splitting your data by delimiters, and replacing values can be done on the SQL side in import mode.
I hope you’ll find these few quick tips helpful on how to get past certain limitations when using Direct Query. If you would like to learn more tips or more about your Azure environment, please click the link below or contact us—we would love to help you grow your business with data and take your business from good to great.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.