Execute Stored Procedure

I have a stored procedure in Sql Server which populates a table when it runs. I want to create a BI report which Executes said SP and then reads and displays the data from the table that was just populated by the SP.

Any ideas?

Thanks.