Forum Discussion

phyten's avatar
phyten
Helper I
9 years ago

Problems Querying Salesforce Objects

I saw that I can connect to salesforce objects via PowerBi Desktop. Now I am trying to get everything going within apps.powerbi.com, I just couldn't find a way to connect to the salesforce objects th...
Need Help
MEclay's avatar
MEclay
Frequent Visitor
9 years ago

Anonymous Hi,

Can you answer the question of whether or not it is possible to connect to Salesforce Objects (Not Salesforce Reports) via the web service?

And if not, is there a way to refresh a dataset that has been published (from desktop -> webservice) without opening power BI desktop.

 

These seem like straightforward questions.

 

Thanks,

Matt

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi MEclay.

 

>>Can you answer the question of whether or not it is possible to connect to Salesforce Objects (Not Salesforce Reports) via the web service?

 

I can connect to salesforce database on service side and refresh.

 

 

 

 

Regards,

Xiaoxin Sheng

  • MEclay's avatar
    MEclay
    Frequent Visitor
    9 years ago

    Anonymous Hi,

    Sorry for the confusion, but that's connecting to the Reports functionality in salesforce.

    There are two ways to connect to Salesforce, at least with many connectors:

    1. Salesforce Reports

    2. Salesforce Objects

     

    Salesforce Objects let's you connect/retrieve information directly from their database Tables.

    The Power BI desktop version shows connections for both Reports and Objects. But when I use web service it just shows connections for Reports - which you have taken pictures of. They are two different things, and I'm thinking that webservice cannot connect to "Salesforce Objects" directly.

     

    Below is a picture of the connections available in Desktop:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Thanks,

    Matt