on 05-11-2017 8:12 AM
Good morning
i am trying to connect excel power pivot to sap business one server
after i connect to the server and choose select from a list of tables and views to choose the data to import and click next
i receive this massage
No tables were found in the data source. Check the connection information and login credentials.
can you please send me instructions how to connect the sap business one database to the excel power pivot?
Hi,
have you installed SQL Native-Client ?
you need to connect the "sa" User... or you have to setup a new User in SQL-Server, that has the authorizations to "read/Select" the tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
How did you connect Excel to SAP Business One server? Do you have valid password for accessing server?
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.