Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

need help with direct query, visualization

I have two sql queries - one that has order no, shipped qty and pending qty and the second sql query has order no and no.of days the order is on hold, i need a visualization that has all information ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

I have one more question, 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?

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

Hi,

Try to aggregate the data that you're bringing into Power BI as much as possible by using filterations. You can customise the SQL code in direct query but Its not best practice. If you have 10 work orders and you need to report only 1 then bring only one. 

  • Push calculated columns and measures to the source where possible – the closer they are to the source, the higher the likelihood of performance.
  • Optimize! Understand the execution plans for your queries, add indices for commonly filtered columns, etc.

If you have billion records to be imported then direct query is the only option but make sure your server performance is good without any Network latency.

If you're more specific about what you're trying to achieve or visualisation that you're trying to do would be helpful. 

Finding a match can also be achieved via Lookup Dax function.