Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.