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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
LasNoches
New Member

Direct query issues

Power Bi query, using direct query does not support use such as 'DECLARE', 'WITH', or even 'ORDER BY' , not sure why the developers does not use this tool at full potencial, but for sure have some potencial to improve. If the developers doest not find interesting or change the permission from direct query, maybe allows us to read an sql file .

1 REPLY 1
foodd
Super User
Super User

To Quote Chris Webb: "What can you do to work around this? There is really just one answer: model your data the way Power BI likes it (i.e. as a star schema) before it gets to Power BI. It’s the now-famous Roche’s Maxim. Even if you aren’t running into this limitation using SQL queries as the source of a table is a bad idea because it makes maintenance difficult and you end up doing any expensive transformations at query time and paying the performance penalty over and over again. And yes, I know, some of you don’t have permission to create views or get the data modeled correctly in the source and I know it’s tough, but that’s the way it is."

 

You are encouraged to search for an existing idea and vote for it or create a new Idea at https://aka.ms/PBI_Comm_Ideas in support of adding support.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors