Smartstaff
1,385
edits
Changes
→Using Excel Data Tab
=Overview=
There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query.
Example below shows how to pull OData feed via the Excel Data Tab.
=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
[[Image:OData-Excel1.PNG|500px|border400px]]
4. From the dialog box ''''Data Connection Wizard ''', enter the endpoint link and the credentials if using the private endpoint link. [[Image:OData-Excel2.PNG|400px]] 5. Select the report (collection) to import. [[Image:OData-Excel3.PNG|400px]] 6. Click '''Next''' and then '''Finish''' [[Image:OData-Excel4a.PNG|400px]] [[Image:OData-Excel4b.PNG|400px]] 7. Data from report will be imported into Excel. [[Image:OData-Excel5.PNG|400px]] =Troubleshooting=<!--see ticket 69942 - OData with https gives error-->1. TLS1.2 security protocol should be enabled on your local machines before you can import OData with HTTPS link. By default, MS Office do not accept this protocol by default.
=See Also=
