Power Connect can change the data connection in your Excel Power Pivot Workbook to SSAS Tabular, Power BI or SharePoint connection.
Users spend a lot of time developing visualizations in Excel that is connected to the Power Pivot Model. There are a lot of scenarios in which you need to change the connection from the Excel Workbook Power Pivot Model to a more scalable solution. However, there is no option in Excel to switch the connection.
Power Connect changes the connection in your workbook to a new data source:
From Power Pivot to SSAS TabularWhen it is time to move the Power Pivot Workbook to SSAS Tabular, just restore the Power Pivot model to the SSAS Tabular Server, or setup Power Update to refresh the workbook and then restore it back to the SSAS Tabular Server. How to: |
|
From Power Pivot to SharePointSharePoint is a great way to distribute Power Pivot workbooks. The challenge is to change the data connector from the Power Pivot Workbook to the SharePoint Connection. How to: |
|
From Power Pivot to Power BI.Power BI has a great free feature; “Analyze in Excel”. However, the connections is still pointing to the local Power Pivot Model so in order to take advantage of the Analyze in Excel feature, users will have to recreate Pivot Tables and visualizations again. Not if use Power Connect How to: |
|
Read about how Power Update can help you refresh your models.
Contact us today for pricing information |
|