cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Important Concepts of DirectQuery

Before opting to go with a DirectQuery connection, it is important to get a better understanding of it.


• Better scalability since extremely large datasets can be used for building reports and the size limitation is only for the data source itself.
• No need for data refresh since its coming as a real time data.
• Pre-Built models in some data sources can be used instantly.
• DirectQuery reports always work on the current data and the hard work is carried out where it should be done on the server side.
• In case of re-query of data, server hits can be avoided to a great extent since the application would reuse already existing data
• It is possible to later switch from DirectQuery to Import mode if needed.
• All tables must come from a single database that is a single data source only. There is simply no way of combining data from multiple sources
• Few limitations are placed on the DAX expressions that are allowed in measures
• Some limitations on Data modelling such as auto-detect relationships between tables and relationships are limited to a single direction
• Built-in Date hierarchy is not available

5 REPLIES 5
Highlighted
Super User IX
Super User IX

Re: Important Concepts of DirectQuery

@reshma_K_Nath , Thaks for sharing. Best way write a blog on the power bi community.

Please contact admin @JCM_iTalent  , to understand the process. Send a message from community mail to the id.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Microsoft
Microsoft

Re: Important Concepts of DirectQuery

@reshma_K_Nath If you are interest in writing a blog for us, please click on the Message Admins to the right of the Community Blog.

Message Admins Blog.PNG

Thank you.

Highlighted
Super User VI
Super User VI

Re: Important Concepts of DirectQuery

I've created direct query models across data in different databases. You have to create views in a single database pointing to the other databases, then connect to those views.


There are some limitations with visuals too in Direct Query.

 

Good writeup!



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Community Support
Community Support

Re: Important Concepts of DirectQuery

Hi @reshma_K_Nath ,

 

Thanks for your sharing. Great summary.

But there is one thing to note: 

 


• All tables must come from a single database that is a single data source only. There is simply no way of combining data from multiple sources


 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
New Member

Re: Important Concepts of DirectQuery

Thank you for the information. Much appreciated!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors