Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to join two DMV tables in DAX studio

 


I am looking for a way to do a LEFT JOIN like in SQL but with DAX. I have two tables employee table and department table. I want to join two DMV tables(views) in DAX studio.

I have tried using the evaluate function EVALUATE NATURALINNERJOIN($SYSTEM.DBSCHEMA_COLUMN,$SYSTEM.TMSCHEMA_COLUMNS) but getting syntax error.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Mate, you CANNOT query DMV's through DAX. DMV's do not belong to a model. They are queried via a limited version of SQL.

Best
Darek

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Mate, you CANNOT query DMV's through DAX. DMV's do not belong to a model. They are queried via a limited version of SQL.

Best
Darek
Anonymous
Not applicable

Can you possibly share what the operators, functions, etc. are in this "limited version of SQL?"

 

I am using DAX studio to query the DMVs and have learned that some operators just don't work like they do in 'real' SQL. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.