Forum Discussion
Problems Querying Salesforce Objects
hi Anonymous I've connected my salesforce credentials via those steps. However, the data is still not updating when I refresh dashboard or reports based on the dataset.
I think this is how it's intended to work though - I notice that it looks like the data loaded in Power BI desktop is stored on my desktop (72MB file), therefore a refresh to salesforce isn't re-pulling that data - it's not really doing anything.
I think the refresh only pertains to data that was originally accessed through the Power BI webservice.
Thanks,
Matt
Hi MEclay,
I think it may related to your network, perhaps you can submit a support ticket.
Regards,
Xiaoxin Sheng
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
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
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