cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mike282
Helper III
Helper III

Is it less efficient to run direct query on a SQL database with a custom query

Hi all,

 

So I'm trying create a direct query model against my SQL database but there are 3 tables that I want appended to each other as one table first. Say I don't have access to our DB admin to just combine them at the source is it less efficient to run a Direct query against a DB with your own SQL statement?

 

An example below:

image.png

 

I know for example running your own SQL statement for import prevents any further query folding for additional transformations you may do in Power Query but how badly does this affect direct query?

 

Would you advise another method of doing this via direct query? Should I setup my direct query tables separately and create a union table via DAX?

 

Kind regards,

Mike

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Mike282 , Create this as a view on database and try to use that

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

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Mike282 , Create this as a view on database and try to use that

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

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.