Forum Discussion
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError"
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?
- What is the underlying data source? Connection mode?
- At what step does the problem occur? (when data loading, transform data or refresh?)
- 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
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.