Power BI Schedule Refresh Not Working

[glennescarayan]

Hi All,

Anyone who experinence an issue about power bi refresh not working? Power BI Gateway is up, permissions is validated but still receiving this error below:

"Something went wrong"

Refresh failed becuase the datasets requires a gateway. Please select a gateway from the dataset.

Activity ID:xxxxxxxxxxxxxxxxxxxxx

Request: xxxxxxxxxxxxxxxxxxx

Correlation ID:xxxxxxxxxxxxxxxxxxxxx

Time:Jan5 xxxx

Service Version: 13.0

Client Version: 2214.4

Cluster URI: https://company.url.com

Steps Taken: Download and configure power bi standard, reset gateway, check permission, user is able to upload datasets from local machone (excel) and oracle bit not able to refresh and update the credentials.

Please advise.

Thanks,

GCE

[MAwwad · Accepted solution]

It seems that you're facing an issue with refreshing your Power BI datasets because they require a gateway, but the gateway is not being selected or is not configured properly.

Here are some steps you can take to troubleshoot and resolve the issue:

1. Verify that the Power BI Gateway is installed and running. If it is not, download and install the latest version of the gateway.

2. Check that the gateway is connected to the correct data source. You can do this by going to the "Settings" page in the Power BI Gateway and checking the "Data source credentials" section.

3. Make sure that the user account you are using has the proper permissions to access the data source through the gateway. This includes both the necessary permissions to the data source and to the gateway itself.

4. If you are using a data source that requires a specific version of the gateway, make sure that the version of the gateway you have installed is compatible with the data source.

5. Try resetting the gateway. This can be done by clicking on the "Reset gateway" button in the "Settings" page of the gateway.

6. If the issue persists, check the Power BI service logs for more detailed information about the error. The logs can be found in the "Diagnostics" page of the Power BI service.

7. Try to refresh your dataset by clicking the "Refresh now" button on the "Datasets" page in the Power BI service.

8. If the above steps do not help, you can try to delete the dataset and re-upload it.

9. If the issue still persists, try to contact Power BI support for further assistance.