Create stored procedure in SSAS Tabular model

Question

Is it possible to create a stored procedure in SSAS Tabular Model? I need to invoke a stored procedure from a Fact table in SSAS Tabular model. The results are stored in a temporary table. My client does not want the stored procedure to be stored as an object on the database.

Answer 1

Importing to Tabular via a Stored Proc

This link here should be the answer to your question.

I think something to be mindful of is whether or not your temp tables' results will produce a predictable column output.