Urgent Need help - Something gent wrong (Not sure where)

[xiumi_hou]

Dear all, 

I used to published a report to the power BI service. Recently, I downloaded this report and changed the source setting(file path) and republished with the same name. The refresh works well at my desktop verson, however when I publish to the service, it's not working. Below is the error code.

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":"MySQL: Unknown column 't0_1' in 'field list'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"127.0.0.1:3306;suitecrm"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Unknown column 't0_1' in 'field list'"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: f_calls.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: d368c075-e20e-4c0f-b443-7360f3ca143d
Request ID: 7c68bb61-e02a-3787-afbc-b2c859579d20
Time: 2020-07-04 01:41:58Z

[xiumi_hou]

I used to published a report to the power BI service. Recently, I downloaded this report and changed the source setting(file path) and republished with the same name. The refresh works well at my desktop verson, however when I publish to the service, it's not working. Below is the error code.

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":"MySQL: Unknown column 't0_1' in 'field list'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"127.0.0.1:3306;suitecrm"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Unknown column 't0_1' in 'field list'"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: f_calls.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: d368c075-e20e-4c0f-b443-7360f3ca143d
Request ID: 7c68bb61-e02a-3787-afbc-b2c859579d20
Time: 2020-07-04 01:41:58Z

[v-yingjl · Accepted solution]

Hi @xiumi_hou ,

So you haved re-configured the data soucre of the gateway and the gateway worked fine right?

If so, please note this error message:

"Unknown column 't0_1' in 'field list'"

Seems like there is an undefined column in your data source, please check your column name of data source in details, delete all the same name reports in power bi service, republish it to power bi service and configure the right path and data source in the gateway to try it again.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

Does your gateway have access / permission to the new data sources?

[xiumi_hou]

@jdbuchanan71 Thanks for answering. Yes, the gateway works well and with the permission to those files.  It used to worked pretty well,  not sure why I changed the data source file and it not worked now.... but it worked at my desktop version. Any advice? Thanks

[jdbuchanan71]

Check under the data source credentials, it's the only thing I can think of.

[xiumi_hou]

@jdbuchanan71 Thanks for this. The admin has granted credentials, I guess something wrong with my tables since it works on my desktop version...