Connection to Salesforce reports not working in latest version 2.61.5192.601

[SteveRudd]

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

[SteveRudd]

Is this really still not fixed? BI team is there an ETA for when this will be fixed.

[AliceW]

Strangely enough, it restarted to work for me, but without having to install a new version. The ghost of Christmas future is at work 🙂

[SA_NYC]

Thanks, your note prompted me to check mine, sure enough, back up. So maybe the issue was on the Salesforce side.

[skygriff]

I was having the same issue with (August 2018 version).  Installed the September 2018 version (Version: 2.62.5222.601) and Salesforce Reports are working again.  Hope it works for you as well.

[SteveRudd]

I wish I could say the same :-), even the workaround is being temperamental!

[AliceW]

Sorry to hear that 😞 Hopefully Microsoft releases a new version soon. 

[AliceW]

I have the same problem...

[AliceW]

Update: I've pasted the text you've provided (thanks!) in a blank query, Advanced Editor, but I can only see some of the reports. Of course, the one I need is NOT present.

What's going on? 

[AliceW]

Update 2: I've changed the report name to move it up the alphabetical list. It was posted, BUT it can't refresh because it is stuck updating my credentials. Guys, don't make me go back to Excel.

[DCGoerke]

@AliceW

So I found a fix to this issue. The problem was with the newest update. I uninstalled me Power BI and then downloaded and installed a previous version. I went two versions back just to be safe. I had to make small changes in my report due to the earlier version, but it was very simple and easy. Nothing to dread. I have a copy of the version I used if you all can’t find it.

[RubinaHussain]

How do you go back to old versions of power BI? I can't seem to find them for downloading.

Regards,

Rubina

[AliceW]

That is a great idea! I'll do just that until Microsoft fixes the issue. Thank you!

[SA_NYC]

Anyone else having an issue connecting to Salesforce in the powerbi.com service to set up a scheduled data refresh? I'm getting this timeout. This didn't seem to happen previously, only since the recent release.

[simbiotix]

I am having the same issue. Does anyone know when a patch will be availible? 

[v-yuezhe-msft]

@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

[hello789567]

I was having the same issues with connecting to SalesForce Reports, and this worked for me! Thank you so much!

[DCGoerke]

@v-yuezhe-msft

I am having the same issue. I can load salesforce objects but not salesforce reports. I created the blank query and I was able to see 2000 reports that way but we have way more than 2000 reports so this doesnt work for me to try and load my reports that way. Is there a fix for this or a fix in progress?

[hello789567]

@DCGoerke

This was happening to me as well with having almost 5000 Sales Force reports, so what I did after I got the list of reports to show(Limited view of course) was copy the report ID/name found in the the web address. Take the report ID/name and then filter the query to that.

Report ID/NameFilter Name Column

[DCGoerke]

@hello789567

That is also a great idea. I was finding that I was having issues with my maps pupulating as well, and I found the older version gave me no issues. 

I would say if you didnt need maps, this would absolutly be a viable fix.

[AliceW]

Fust FYI, that advanced query text fix only works for existing reports 😞

I've created a couple of them an hour ago and they are not in the tables' list.