Forum Discussion
Power Query - Cannot see my Salesforce reports
- 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.
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
- AshokThangavelu4 years agoRegular Visitor
So, what's the solution for it. How do i see my reports?
- v-yingjl4 years agoCommunity 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.