cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
glennescarayan
Regular Visitor

Power BI Schedule Refresh Not Working

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

1 ACCEPTED SOLUTION
MAwwad
Super User
Super User

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.

View solution in original post

1 REPLY 1
MAwwad
Super User
Super User

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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors