Difference between revisions of "Adding an OData feed power query to Microsoft Excel"

Adding an OData feed power query to Microsoft Excel (view source)

25 bytes removed , 23:27, 13 December 2020

no edit summary

3,246

edits

@@ Line 19: / Line 19: @@
 #: The fourth entry will apply the login approach to the ODataLink model and data file combination.
 # Click '''OK''' to save the login details.
-# In the next dialogue, select the endpoint to retrieve.
+# In the next dialogue, select the endpoints to retrieve and click the '''Load''' button.
-#: If wanting to retrieve multiple endpoints at once, tick the '''Select multiple items''' checkbox and tick two or more endpoints.
+#: If wanting to retrieve multiple endpoints at once, tick the '''Select multiple items''' checkbox and tick two or more endpoints. This will add one Power Query and OData Feed per endpoint selected.
-# Click the '''Load''' button.
-#: Selecting multiple endpoints will add one Power Query and OData Feed per endpoint selected.
 Once created, you can [[Editing an OData feed power query in Microsoft Excel|edit the data using Power Query]].