Forum Discussion

SteveRudd's avatar
SteveRudd
Helper I
8 years ago
Solved

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

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    SteveRudd,

    Expand required table from Data column.

    Regards,

    Lydia

33 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • DCGoerke's avatar
      DCGoerke
      Regular Visitor

      Anonymous

       

      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's avatar
        hello789567
        Advocate I

         

        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

    • hello789567's avatar
      hello789567
      Advocate I

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

    • SteveRudd's avatar
      SteveRudd
      Helper I

      AnonymousHow do I tell if it has connected correctly?

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        SteveRudd,

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

        Regards,
        Lydia

  • 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.

     

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

    • AliceW's avatar
      AliceW
      Power Participant

      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's avatar
        AliceW
        Power Participant

        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.

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

    • AliceW's avatar
      AliceW
      Power Participant

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

      • SteveRudd's avatar
        SteveRudd
        Helper I

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