Forum Discussion

AshokThangavelu's avatar
AshokThangavelu
Regular Visitor
4 years ago
Solved

Power Query - Cannot see my Salesforce reports

I have successfully connected to salesforce but cannot see any of the reports which i have created, i do see reports from others. Not sure if the reports need to be saved in a perticular folder. Can someone please provide some insights here?

Power query Salesforce Connection 

  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi AshokThangavelu ,

    You can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Salesforce Object connector doesn’t have the 2000 row limit.

     

    In addition, if you still could not see your reports in Power BI, you can try to rename your report by adding "!!!!" in in front of naming string: "My_Report" -> "!!!!My_Report".

     

    Refer: Can´t I see all my Salesforce reports in Get Data 

     

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    If you use Salesforce Reports connector,please note that there is a limitation with Salesforce reports as a source that limits the rows you can pull in per report to 2000. 

     

    If you got the answer then please accept this as a solution 

     

      • v-yingjl's avatar
        v-yingjl
        Community Support

        Hi AshokThangavelu ,

        You can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Salesforce Object connector doesn’t have the 2000 row limit.

         

        In addition, if you still could not see your reports in Power BI, you can try to rename your report by adding "!!!!" in in front of naming string: "My_Report" -> "!!!!My_Report".

         

        Refer: Can´t I see all my Salesforce reports in Get Data 

         

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