Dataset With Missing Credentials Error

If your API runs on a local server (like your dev machine), you’ll need to install the On-Premises Data Gateway.

You can download from here: https://powerbi.microsoft.com/en-us/gateway/ and install it on the machine where your API is running.

In Power BI Service, go to: Settings > Manage Gateways > Add Data Source.

Then add your API URL and choose authentication method (Anonymous, Basic... depending on your API).

In Power BI Service: Settings > Datasets > Gateway Connection and assign the dataset to use the gateway and the registered data source.

 If you're using localhost, you may need to expose it as http://<your-machine-name>:5012/... in the gateway instead of using localhost, as localhost from the Power BI Service refers to the gateway machine.

If you want to avoid using a gateway, you need to host your backend API on a publicly accessible domain (Azure App Service, Render, Vercel).

Then, in Power BI, update the data source URL to the public one.

In Power BI Service, go to Settings > Datasets > Data source credentials and set them (Anonymous, Basic Auth, or OAuth depending on your API). Scheduled refresh should now work.