Refresh via Redshift gateway fails in Service - PBI Desktop successful

[Volker]

Dear community members,

I have a dataset connected via Redshift data gateway to data (.txt) within AWS cloud. For some weeks daily scheduled refresh within PBI Service worked perfectly fine.

One week ago refresh aborted within seconds after start with error message below. Data is available in the cloud and to my knowledge there was no change in the setup.

When I downloaded the dataset and refreshed it within PBI Desktop it was successful. Within PBI Service continues to fail also after importing the dataset again.

Do you have any ideas what could be the problem and possible solution?

Unforutnately I cannot provide details about gateway configuration because it was set-up by my IT.

Thanks a lot for your ideas.

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The column 'bu_bw' of the table wasn't found."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"bu_bw"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Inventories.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: e7155e77-62dd-4f54-9140-61369d918444
Request ID: 9939d5cb-ed0d-204e-3fbb-4d9673895249
Time: 2020-06-16 13:44:12Z

[v-shex-msft]

HI @Volker,

I'd like to suggest you check your AWS cloud setting if they blocked power bi service requests so that refresh operations failed.

Power BI URLs for whitelisting 

Azure IP Ranges and Service Tags – Public Cloud 

Regards,

Xiaoxin Sheng

[GilbertQ]

Hi there

The column in your text file called bu_bw is missing.

Could you also make sure that you have got the latest version of the On-Premise Gateway installed. The latest version is 3000.45.7

[Volker]

Hi Gilbert,

thanks for the hint.

But column is available (Refresh in PBI desktop successful) and first check by IT says Gateway is up and running and set-up fine.

We'll further investigate but currently have no idea anymore what could be the problem.

[hazeltwe]

Hi @Volker did you ever find a fix for this? I'm coming up against the same issue

[Volker]

Hi,

as far as I record we were able to solve. But I don'T have documentation and as it was 3 years ago I really do not know the details anymore.

Sorry.