Forum Discussion
need help with direct query, visualization
Hi,
First of all what's the requirement to use direct query? are you reporting on real time data? You'll not get all the features in PBI when using Direct Query. If possible, limit the number of rows returned from SQL and do the merge in SQL itself. You can use left Join which will bring all the data from 1st table and matching data from second table, non matching records you can remove using creating a filter using Dax. Try to keep your model simple as possible.
All the best.
LW
I am working on real time data and i need to use a direct query, do you sugest that i write a sql code and perform an outer join there and then perform visulisations on power bi?
Push back all the processing to the source( direct query relies on server performance as well, so make sure its sufficient enough to cater your requirements ), use a stored procedure to calculate in server side or use a view.
Direct query only to be used when you need real time analytics and large data volume where local RAM cannot handle. Use import mode and see how it goes.
Thanks
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- 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?