cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Native SQL

It is great that we can use native SQL when creating a connection to a database. The issue we have is many of our users are not well versed with writing native SQL; Oracle / MS SQL or others. We're even getting some users selecting * from a number of tables then doing the equivalent of a where clause in the Data Model. This causes some models to take many hours to refresh when the reality is the data model is a very small subset of the entire data being returned by the SQL server. They can use client tools to build the SQL statements but many reporting tools have user interfaces to add in the objects and create the links. It would be much better to be able to have a user interface to create the statement or even perhaps some logic to look at the data being returned then advise if the resultant data model is significantly smaller than the original. Thanks
3 REPLIES 3
Highlighted
Continued Contributor
Continued Contributor

Re: Native SQL

If you have an idea to improve the query building experience, submit it here: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

This challenge could maybe be solved with additional user training, particularly around the Query Folding capabilities in Power Query: https://blog.crossjoin.co.uk/2017/06/11/query-folding-and-writing-your-own-sql-queries-in-power-quer...

Highlighted
Community Support
Community Support

Re: Native SQL

Hi @saj,

 

We can enter the sql statement here directly to filter the data in advance.

12e.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Helper II
Helper II

Re: Native SQL

Thanks @v-frfei-msft but I'm not sure you read the email. We know we can write native SQL thanks.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors