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 pop...