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

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

1,163 bytes added , 18:10, 14 December 2020

Undo revision 442 by Nic (talk)

3,246

edits

@@ Line 11: / Line 11: @@
 #: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead.
 # Paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''.
+# In the next dialogue, select from '''Anonymous''' or '''Basic''' matching the '''Login Type''' setup for the model.
+# If choosing '''Basic''', additionally enter your username and password used to login to odatalink.
+# In the dropdown, choose the fist or second entry.
+#: The first entry will apply the login approach to all of ODataLink. (Recommend for those working with a single ODataLink account).
+#: The second entry will apply the login approach to the ODataLink account. (Recommend for those working with multiple ODataLink account).
+#: The third entry will apply the login approach to the ODataLink model.
+#: 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 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. This 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]].
 = Related Topic =
 [[Integrating ODataLink with Microsoft Excel]] <br />