cancel
Showing results for 
Search instead for 
Did you mean: 

connect sap business one to power pivot

0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

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

Regards,

Nagarajan