Skip to Content
0

connect sap business one to power pivot

May 11, 2017 at 07:12 AM

71

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K May 14, 2017 at 10:58 AM
0

Hi,

How did you connect Excel to SAP Business One server? Do you have valid password for accessing server?

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
Markus Schäfer May 17, 2017 at 08:27 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded