Forum Discussion
Connect Power BI to Salesforce Sandbox Report
Anonymous,
What error message do you get in Advanced Editor? Based on the following similar trhead, you are able to use https://test.salesforce.com for all sandbox accounts.
https://social.technet.microsoft.com/Forums/en-US/dc66d551-e4b8-4677-85ec-05dd8634cc39/connect-to-salesforce-sandbox?forum=powerquery
http://community.powerbi.com/t5/Desktop/Power-BI-Desktop-salesforce-object-connector-quot-please-specify/td-p/68459
Regards,
Lydia
Hi Lydia, Anonymous
I tried connect via custom, by using: https://test.salesforce.com and when I input my credentials,
I received this error : The service returned an invalid token. Please contact your IT administrator if this issue persists.
When I connect to production, and go to advance editor to repalced any report ID code to Sandbox report ID codem for example
from "00O44000003pq6dEAB" to "00O1g000000OWCYEA5", I received as of below :
DataSource.Error: Web.Contents failed to get contents from 'https://***.my.salesforce.com/services/data/v29.0/analytics/reports/00O1g000000OWCYEA5?includeDetails=true' (404): Not Found
Details:
DataSourceKind=Salesforce
DataSourcePath=https://login.salesforce.com/
Url=https://****.my.salesforce.com/services/data/v29.0/analytics/reports/00O1g000000OWCYEA5?includeDetails=trueIs it because my data source path is still production and not custom ?
How do I go about login through custom ? My salesforce admin must provvde what access right, so I can access the sandbox mode ?