Change Persist Security Info from False to True.

Enter your username and password of an administrator with reporting permissions for the Questionmark account you are trying to access in the User ID and Password fields.This should refresh the window and display the information. If this happens, click on the Providers drop-down list and reselect Microsoft Data Feed Provider. Change Integrated Security from SSPI to Basic.ĭue to a bug with Power Pivot, sometimes the Advanced window is blank when opened.Enter a Friendly connection name and the Data Feed URL (the URL of the Results API service for the Questionmark account you want to access).In the Get External Data section, click From Data Service, and then click From OData Data Feed.Click the Power Pivot tab in the ribbon.The following instructions demonstrate how to connect to the Results API using Power Pivot in Excel 2016: Power Pivot comes automatically installed with the Professional Plus versions of Excel 20. The Power Pivot add-in for Microsoft Excel 2010 can be downloaded from Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010.

Power pivot for excel 2016