Magic_Sponge
New Member
- Joined
- Oct 28, 2021
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi - I am sure I must be missing something very simple here as I can't believe the trouble I'm having.
I have a SQL Server database with a load of tables and data, pretty standard stuff. I have had no problem connecting to this data and pulling it into the PowerPivot data model. Now I have the problem that apparently PowerPivot does not work on Macs, so I need to find an alternative solution.
I was going to use Power Query / Microsoft Query to bring the data in, but I just can't seem to connect to the SQL server. I have managed it once by Get Data --> Other Sources --> OLEDB and using the "Microsoft OLE DB Provider for SQL Server" driver, but then that creates a different problem. I want each user to be able to refresh the data by entering their username and password for the SQL Server, but if I use approach to bring the data in, it seems to 'remember' the username and password, even though I haven't asked it to.
I've tried Get Data --> From Database --> SQL server but I get an error message "We encountered an error while trying to connect. Details: Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context". But these are the exact same credentials I've used to create the connection elsewhere.
Long and short of it is, I need a way to simply bring data in from tables stored in a SQL Server Database that does not use PowerPivot, and allows me to set it so that a user needs to enter their SQL Server Credentials to refresh the data.
Can anyone put me out of my misery?
I have a SQL Server database with a load of tables and data, pretty standard stuff. I have had no problem connecting to this data and pulling it into the PowerPivot data model. Now I have the problem that apparently PowerPivot does not work on Macs, so I need to find an alternative solution.
I was going to use Power Query / Microsoft Query to bring the data in, but I just can't seem to connect to the SQL server. I have managed it once by Get Data --> Other Sources --> OLEDB and using the "Microsoft OLE DB Provider for SQL Server" driver, but then that creates a different problem. I want each user to be able to refresh the data by entering their username and password for the SQL Server, but if I use approach to bring the data in, it seems to 'remember' the username and password, even though I haven't asked it to.
I've tried Get Data --> From Database --> SQL server but I get an error message "We encountered an error while trying to connect. Details: Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context". But these are the exact same credentials I've used to create the connection elsewhere.
Long and short of it is, I need a way to simply bring data in from tables stored in a SQL Server Database that does not use PowerPivot, and allows me to set it so that a user needs to enter their SQL Server Credentials to refresh the data.
Can anyone put me out of my misery?