Power Query - Cannot see my Salesforce reports

[AshokThangavelu]

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 

[AshokThangavelu]

So, what's the solution for it. How do i see my reports?

[Anonymous]

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 

[AshokThangavelu]

So, what's the solution for it. How do i see my reports?

[v-yingjl · Accepted solution]

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.