Reply
Frequent Visitor
Posts: 10
Registered: ‎08-16-2018
Accepted Solution

Connection to Salesforce reports not working in latest version 2.61.5192.601

Since updating to the latest version I can no longer query salesforce reports. 

 

I can connect to Salesforce Objects but not reports. 

 

The only change has been to update to the latest version.

 

Fingers crossed this is fixed and a new version is available soon.

 

Thanks

 

Steve

 


Accepted Solutions
Moderator
Posts: 8,656
Registered: ‎03-10-2016

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

@SteveRudd,

Expand required table from Data column.

Regards,

Lydia

View solution in original post


All Replies
Highlighted
Frequent Visitor
Posts: 11
Registered: ‎06-30-2016

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

Same thing here.

Moderator
Posts: 8,656
Registered: ‎03-10-2016

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

@SteveRudd @boujin,

I am unable to reproduce this issue on my side. I can successfully connect to Salesfroce report in the latest version of Power BI Desktop(2.61.5192.601).

Could you please add a blank query in Power BI Desktop, and then paste the following code to check if you can connect to Salesfroce report?

let
    Source = Salesforce.Reports()
 in
    Source



Regards,
Lydia

Frequent Visitor
Posts: 10
Registered: ‎08-16-2018

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

[ Edited ]

@v-yuezhe-msftHow do I tell if it has connected correctly?

 

Moderator
Posts: 8,656
Registered: ‎03-10-2016

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

@SteveRudd,

Could you please post a screenshot about the result after using the above code?

Regards,
Lydia

Frequent Visitor
Posts: 10
Registered: ‎08-16-2018

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

[ Edited ]

@v-yuezhe-msftHopefully this time the picture is showing

Frequent Visitor
Posts: 10
Registered: ‎08-16-2018

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

I'll try one last time to add a picture, if not if you PM me an email address I can send it therePower BI.JPGpic 1

 

Moderator
Posts: 8,656
Registered: ‎03-10-2016

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

@SteveRudd,

Please paste the above code to the Advanced Editor of the blank query. there is an example for your reference.
2.PNG

Regards,
Lydia

Frequent Visitor
Posts: 10
Registered: ‎08-16-2018

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

[ Edited ]

Thanks @v-yuezhe-msft that looks better :-) 

Capture.JPGpic 2

Moderator
Posts: 8,656
Registered: ‎03-10-2016

Re: Connection to Salesforce reports not working in latest version 2.61.5192.601

@SteveRudd,

Expand required table from Data column.

Regards,

Lydia