Smartstaff
1,385
edits
Changes
→Using Excel Data Tab
1. Go to the '''Data''' tab<br/>
2. Click '''From Other Sources'''<br/>
3. Choose '''From OData Feed''' from the dropdown list<br/>
[[Image:OData-Excel1.PNG|400px]]
4. From the dialog box ''''Data Connection Wizard ''', enter the endpoint link and the credentials if using the private endpoint link.<br/>
[[Image:OData-Excel2.PNG|400px]]
5. Select the report (collection) to import. <br/>
[[Image:OData-Excel3.PNG|400px]]
[[Image:OData-Excel4b.PNG|400px]]
7. Data from report will be imported into Excel.
=See Also=