Issue with Gen1 Dataflow not refreshing

Hi cath1ynn 

The issue with your Power BI Service dataflow failing while the same API query works fine in Power BI Desktop is likely due to authentication, network restrictions, or API rate limits. Since Power BI Service runs in the cloud, it might be blocked by API security settings, such as IP whitelisting or stricter rate limits for cloud-based requests. Additionally, authentication settings in Power BI Service may not match what works in Desktop, so re-entering credentials in the service might help. Another possibility is that recent changes to Gen1 dataflows have introduced compatibility issues, and migrating to Gen2 dataflows could resolve them. Also, some APIs impose request throttling, which could be affecting the service-side refresh, so adding delays between requests might help. The error message in Power BI Service provides only a Request ID and Activity ID, making troubleshooting difficult, but checking API logs or contacting Microsoft Support can provide more details. Reviewing network access, updating authentication, and testing in a cloud environment (like Postman) can help pinpoint the issue. If none of these solutions work, raising a Microsoft support ticket may be necessary.