I am trying to use the on-demand refresh in Power BI to refresh data from a REST API. I use a combination of simple direct requests and queries that loop through the pages. The refresh now feature works in Power BI Service because the app detects the correct connection string containing all the required endpoints, but this is not the case in Power BI Report Server.
When I look at the connection string in Power BI report server, the required endpoint is missing. Since there is a required endpoint for this specific API request we see a bad request on the server because Power BI report server only detects the connection string as “URL” and not “URL?required=1”, the required url. I’ve tried rewriting my queries in many ways, but nothing seems to work and there’s no way to manually edit the connection string in Power BI Report Server. Has anyone faced this problem?
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
