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 : http://office.microsoft.com/en-in/excel-help/make-changes-to-an-existing-data-source-in-power-pivot-HA102836948.aspx
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.