Direct Query

[Anonymous]

Hi

I am using a SQL direct query to make visualizations. The query is about 600 lines and right now am using a SQL code – where am bringing in all the order numbers (the reason why I have about a billion rows), in a direct query – can I customize the SQL code? I can use the SQL query to one particular order number, but I need to be able to look for all order numbers, instead of going to the advanced editor and changing the order number, is there any other way I can work on this? If so how?

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You could  customize the SQL code when connect to SQL

https://community.powerbi.com/t5/Desktop/Custom-SQL-instead-of-table-or-view/td-p/96463

Best Regards,

Lin