Salesforce Reports Connection Issues in Power BI & Power Query

[Anonymous]

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 the data, I get errors related to the credentials. I have to "Clear Permissions" and sign in again multiple times before I can get the data successfully. I have also tried various Privacy levels (None, Organization, Private...). My login is a single-sign on.

If it were not working at all, I would have assumed some issues with the credentials. But it works after multiple attempts. Is this a common issue with Salesforce data connections in Excel/Power BI?

Screenshots attached showing the different errors I get every time I click on connect.

[lbendlin]

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.

[ARJ1202]

@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

[Anonymous]

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.

[lbendlin]

Not your fault. It's a brain damaged connector combined with automation-hostile SSO.