Any workaround to use Stored Pro with direct query?

Question

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?

greg_deckler · Answer

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

anonymous · Answer

HI&nbsp;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

Forum Discussion

Any workaround to use Stored Pro with direct query?

2 Replies

Related content

Direct Query Workarounds

Workaround for Transformations Using Direct Query from Dataverse

Stored Procedures in Direct Query mode

PowerBIIntegration.Refresh() PowerApp workaround??

Relationship Workaround