Hi, 

I need to add fields via lookup in my M Language (Excel Power Query Language) Statement. 
For instance, a SOQL query would be SELECT Id, Profile.Name FROM User. 
With Excel Power Query, I can't figure out a way to add the Profile.Name in my statement.
I only can return ProfileId. 

Any Idea ? 

Hi, 

I'd like to do reporting outside Salesforce. I need to be able to run a SOQL Query that return a Sum(Amount) directly in Excel. I know I can do this with Conga Composer but I can't use this tool. I tried with Excel Connector but it doesn't work = it returns rows. 

Anyone has an idea ? 

Nathan

Hi, 

I'm trying to build a query to returns a list of Opportunity IDs where the Opportunity Owner doesn't match the Account Owner. 

I've tried this : 
SELECT Id FROM Opportunity WHERE OwnerId != Opportunity.Account.OwnerId. 
But it doesn't work.

Any Idea ? 

Hi, 

I'd like to execute something like this : 

SELECT Id
FROM Opportunity
WHERE OwnerId != Opportunity.Account.OwnerId

Unfortunately, I got this error message. 
MALFORMED_QUERY: 
FROM Opportunity
                ^
ERROR at Row:3:Column:17
Bind variables only allowed in Apex code




Is there a work around ?

Hi, 

I'd like to execute something like this : 

SELECT Id
FROM Opportunity
WHERE OwnerId != Opportunity.Account.OwnerId

Unfortunately, I got this error message. 
MALFORMED_QUERY: 
FROM Opportunity
                ^
ERROR at Row:3:Column:17
Bind variables only allowed in Apex code




Is there a work around ?