Any workaround to use Stored Pro with direct query?

[Anonymous]

I need to use a Direct query to have real-time data and would like to call a Stored Proc.

Is there any workaround to achieve this?

[Anonymous]

HI @Anonymous,

AFAIK, current you can't invoke a stored procedure in direct query mode.
I'd like to suggest you create a copy of import mode on the query table that you want to execute the stored procedure.
Regards,

Xiaoxin Sheng

[Greg_Deckler]

@Anonymous ,

Looks like @TomMartens had a way here: https://community.powerbi.com/t5/Desktop/Can-i-call-Stored-Procedure-with-Direct-Query/td-p/267141