Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Adithya_S
Employee
Employee

Can we create Measures on Direct Query? Is there any Limitation to create Measures for Direct Query?

‎12-19-2022 09:45 PM

Can anyone help me with understanding whether it is possible to create Measures for Direct Query data sources? Do you have any supporting document for this? Is there any limitation for measures in DQ?

Any help would be appreciated. Thanking you in advance.

Labels:
Message 1 of 2
198 Views
0
1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

‎12-19-2022 09:56 PM

Hey @Adithya_S ,

 

the answer is simple, measures can be created on top of DQ models.
Nevertheless, there are some limitations in regards to DAX, the best way to start is this document: DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

Hopefully, this gets you started.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Message 2 of 2
190 Views
1 REPLY 1
TomMartens
Super User
Super User

‎12-19-2022 09:56 PM

Hey @Adithya_S ,

 

the answer is simple, measures can be created on top of DQ models.
Nevertheless, there are some limitations in regards to DAX, the best way to start is this document: DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

Hopefully, this gets you started.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Message 2 of 2
191 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All