Forum Discussion
Can i call Stored Procedure with Direct Query?
-> Import vs Direct Query – So at the moment i am loading the queries into Power BI Desktop by using Import Query rather than Direct Query inturn it stores the data in the cloud, which isn’t security...
Hi Pallavi,
The performance depends on many factors.
1. The capability of the Server. (Most of the operations are sent to the Server.)
2. The quality of the network.
3. The size of the dataset.
4. The complexity of the measures.
So using stored procedure might not help. I believe the Direct Query is running in the best way. Usually many people use Direct Query to avoid transfer the whole big dataset.
You can give it a try.
Best Regards!
Dale