I am new to reporting but I have a report in Power Pivot which is using a stored procedure to capture data from a table.
I have tried to upload it to SharePoint but I get errors.
Error # 1: This workbook contains one or more queries that refresh external data....
When I click 'yes' I get another error. 'The following connections failed to refresh'
This is not refreshing my data.