cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteveRudd Frequent Visitor
Frequent Visitor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

@SteveRudd,

Expand required table from Data column.

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

33 REPLIES 33
boujin Frequent Visitor
Frequent Visitor

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

Same thing here.

Moderator v-yuezhe-msft
Moderator

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SteveRudd Frequent Visitor
Frequent Visitor

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

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

 

Moderator v-yuezhe-msft
Moderator

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SteveRudd Frequent Visitor
Frequent Visitor

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

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

SteveRudd Frequent Visitor
Frequent Visitor

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 v-yuezhe-msft
Moderator

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SteveRudd Frequent Visitor
Frequent Visitor

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

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

Capture.JPGpic 2

Moderator v-yuezhe-msft
Moderator

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

@SteveRudd,

Expand required table from Data column.

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 311 members 3,094 guests
Please welcome our newest community members: