Forum Discussion
salesforce service cloud invalid token w both PQuery and PBI desktop
Hi all,
Im trying to connect to Salesforce Service CLoud Sandbox with no luck. I get the error "Service has returned invalid token".
I have the latest PBI desktop and Excel Query installed.
I've also tried to make the registry changes mentioned here.
Has anyone been able to query data from Service CLoud (objects or reports)? Should there be some specific setting done in the Salesforce end to enable data connection? I have atm ordinary user license. And should be able to query data as an ordinary user.
EDIT: also tried to add own IP to allowed list without luck.
Solved!
Thanks to this thread: https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-salesforce-object-connector-quot-please-specify/td-p/68459
The problem must have been that Im operating in Sandbox. Tried to connect directly to the sandbox URL. Seems to be that I needed to use https://test.salesforce.com instead. It may be that the registry changes were needed to. Dont know yet.
1 Reply
Solved!
Thanks to this thread: https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-salesforce-object-connector-quot-please-specify/td-p/68459
The problem must have been that Im operating in Sandbox. Tried to connect directly to the sandbox URL. Seems to be that I needed to use https://test.salesforce.com instead. It may be that the registry changes were needed to. Dont know yet.