Forum Discussion
Salesforce Reports Connection Issues in Power BI & Power Query
hoping for some help with an issue I am facing in connecting Power Bi with Salesforce . I also tried to do this on Power Query in Excel and am getting the same issues. Every time I try to refresh...
yes, that's a common issue with SFDC connectors and SSO.
The SFDC reports connector is pretty useless anyway due to the 2K row limit.
I've created 6 reports, each with less than 2000 rows and the query combines them. Only way I could work on the entire year's data.
This is the first time I'm unable to find a solution online for a computer issue. So i figured I'm the only one facing this issue and must have done something wrong.
Not your fault. It's a brain damaged connector combined with automation-hostile SSO.
lbendlin Anonymous Someone had posted a solution to bypass the 2k row limit. Here is the link. Hope it helps 🙂 https://community.powerbi.com/t5/Power-Query/How-to-Bypass-Salesforce-2000-Rows-Limitation/m-p/900109#M30809
