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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
saj
Helper III
Helper III

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
v-frfei-msft
Community Support
Community Support

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.

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

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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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