Incremental Refresh

Hi Salesforce_BI,

Since you've already verified folding works in Diagnostics, the DM_GWPipeline_Gateway_MashupDataAccessError is Service-side, not your M query. Most common cause: the Connected App's Refresh Token Policy in Salesforce is set to "immediately expire" - long incremental refreshes outlive the token. Switch it to "Refresh token is valid until revoked" in Setup → App Manager → Power BI → Edit Policies.

If you'd prefer an incremental refresh setup that doesn't depend on Power BI Service's OAuth chain at all, Power BI Connector for Salesforce on AppExchange handles auth through its own Connected App inside Salesforce:

Why it might fit:

• Auth lives in your Salesforce org, not in Service credentials
• No 2,000-row limit on reports
• Supports custom fields, custom objects, and joined reports
• 30-day free trial
• Setup docs: https://metricasoftware.com/docs/salesforce/
• Responsive support if you get stuck: https://metricasoftware.com/docs/salesforce/contact-support/

Happy to set up a quick demo if it'd help. Just reach out via the support link.

Cheers,

Metrica Team.