Forum Discussion
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?
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
- AnonymousNot 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
- AshokThangaveluRegular Visitor
So, what's the solution for it. How do i see my reports?
- v-yingjlCommunity 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.
- AshokThangaveluRegular Visitor
So, what's the solution for it. How do i see my reports?