How do I change the datasource location for a PowerPivot report?

Category: sql server powerpivotsp


Developer_46038 on Fri, 09 May 2014 23:26:26

I read a post that said I should see the option to change my PowerView's data connection in the context menu.  But all I see is "Manage PowerPivot Data Refresh"

is there a way to open the file in Excel and put the path\url to the BISM file in the Data connection properties?


M. Mahfoud EL HOUDAIGUI on Fri, 09 May 2014 23:53:00

1. In Excel, Power Pivot tab > Manage Data Model to open the Power Pivot window.
2. In the Power Pivot window, click Home > Connections > Existing Connections.
3. Select the current database connection and click Edit.

Source :

Developer_46038 on Sat, 10 May 2014 00:10:14

Thanks for the answer. But I got confused between PowerView and PowerPivot. I'll have to fire up a new thread.