Forum Discussion
Best way to refresh a Dataset
When attempting a scheduled refresh, is the error message the exact same as the one in the link you posted? If so, have you tried the accepted solution there?
Like yourself, I also have a Postgres DB in AWS and in my experience the gateway config tends to be the root of the problems, but sometimes a gateway is not needed if all your data sources are in the cloud. In these cases, disabling the gateway can fix the issues.
When a gateway is necessary, you can try installing the on-prem Gateway on your own PC and configuring the PBI Service refreshes through there just to test if it works, because if it does then you have determined that the problem is with the AWS gateway.
Hi uif19085,
When you make changes to a report, it is not enough to press Refresh (this only pulls the data again), but you also need to click Publish (icon on the right side) to send the latest version of this .pbix file to PBI Service (the cloud version).
After clicking Publish, find the correct workspace where the report is located, and then overwrite it.
Regarding the other issue you mentioned, I would need to see an error code/description or some details. There can be several reasons why it does not refresh from the cloud, but if the same report is correctly refreshing in PBI Desktop, then it might be a problem with the way the Gateway is set up.
Hi IgnasiVelasco , i'm intrested in avoiding the process of overwriting or at least to make it automated, when i will have many reports I wouldn't want to manually refresh them all. So what do you think is the best way?
When attempting a scheduled refresh, is the error message the exact same as the one in the link you posted? If so, have you tried the accepted solution there?
Like yourself, I also have a Postgres DB in AWS and in my experience the gateway config tends to be the root of the problems, but sometimes a gateway is not needed if all your data sources are in the cloud. In these cases, disabling the gateway can fix the issues.
When a gateway is necessary, you can try installing the on-prem Gateway on your own PC and configuring the PBI Service refreshes through there just to test if it works, because if it does then you have determined that the problem is with the AWS gateway.
Thank you for your feedback. I'll try both solution, i dig a little into this and indeed the problem seems to be the Gateway.
