Forum Discussion
Best Practice. Using sql stored procedure vs importing data from sql server?
Your consultant may have being attempting to satisfy a use case for near real-time data and so was using direct query where he performs all the transformations in database rather than PBImport. And, respectfully, Element115 is only considering one approach for running a stored procedure in PBI which does force you into import. There are other ways your consultant and I know about.
Indeed! First time I see this. Anonymous Could you please explain what @Offset is and why is it needed?
Sometime that won't work with particular queries, though. In that case it is best to create a linked server, and query through the linked server using OPENROWSET technique. (It is normal for a SQL serer to have created a linked server to itself.) This delightful new query, presumes you have created a linked server and it works cleanly. (Please remeber the community strips characters from the SQL sometime, so work it out if so)
😶You'll need to use a procedure that uses a parameter for this to work as described.
