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
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)