Solved: Direct Query

Anonymous · ‎07-09-2019

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 · ‎07-10-2019

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-lili6-msft · ‎07-10-2019

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.