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.
[[Image:OData-Excel4b.PNG|400px]]
7. Data from report will be imported into Excel. Maximum number of rows per pull is 1024.
[[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=
