Skip to Content
avatar image
Former Member

connect sap business one to power pivot

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 14, 2017 at 10:58 AM

    Hi,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 08:27 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded