irelandcas.blogg.se

įrom here you can select which parameters you want to load.Once you have entered your credentials, click Save to continue.

(Note: 'Marketplace key' and 'Organizational account' credentials are not supported by Integration Services.) Select the Basic option if the user requires authentication with a username and password.If you are using a Smart Card, select Current User when you are logging in. Select the Windows option if the user requires Windows authentication.In the next dialog box you need to enter credentials for a valid PlanningSpace tenant user:.Launch Microsoft Excel and navigate to the Power Query tab in the ribbon.Ĭlick the From Other Sources button on the ribbon and select From OData Feed.Įnter the URL (e.g.

Use the Recent Sources button in the Data ribbon to accessĪ list. The data feeds that you create are stored in Excel for future use. Launch Microsoft Excel and navigate to the Data tab in the ribbon.Ĭlick the New Query button on the ribbon and select From Other Sources > From OData FeedĮnter the URL (for example '') of your PlanningSpace data source It is available for downloadįrom Microsoft. Note for Excel 2013 and earlier: Power Query must be installed as an add-on. Note for Excel 2016: Power Query is built-in as the 'Get & Transform' feature. Microsoft Excel's Power Query module can retrieve data directly from Integration Services using an 'OData feed'.