Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError"

[ShareAnonymous]

Hi, I have done everything remotely possible to fixing the following error : 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 '1. Gender:' 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":"1. Gender:"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Assault T.

From removing the colon caught in a table column header to restarting the gateway and setting privacy to none yet I keep getting the error every time I try to refresh the data. If anyone is kind to answer I would really appreciate it.

Please note: I have seen the other solutions to this type of error but it still doesn't apply to my context.

[VBLOT]

Hi,

I can also add that the issue for me was on the Dataflows credentials in the Gateway connections

[Anonymous]

Hi @ShareAnonymous ,

According to your provide error message, it seems there is one column [1. Gender:] can't be found in the table 'Assault T'. In order to make a deep troubleshooting and give you a suitable solution, could you please provide the following necessary information?

1. What is the underlying data source? Connection mode?
2. At what step does the problem occur? (when data loading, transform data or refresh?)
3. Could you please confirm if there is one column named "1. Gender:" exist in the table 'Assault T'?

Looking forward to your reply.

Best Regards

[ShareAnonymous]

Hi Ying
Thanks for responding, here are the answers to the questions you asked;

1. The connection mode is a published web url of an excel worksheet from google forms questionnaire. It was added to powerbi on the Get Data section with the data transformed and the data source name is SercleV1. I'll provide screenshots below.

2. The problem occurs during refresh, upon successful connection to powerbi, when refresh is hit I get the error.
3. Yes the column Gender exists and has been cleared of the semicolon which I thought was the problem initially, but yet the problem persists. I'll provide the screenshots below.

I am expecting your reply thanks so much.