Urgent - refresh not working

[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

[v-xuding-msft · Accepted solution]

Hi @xiumi_hou ,

After changing file path, we need to add a new data source into gateway. Because the original data source can't be changed automatically after republishing and we can't change its path (or server and database) either.

And then map it in settings.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

[Anonymous]

Please share more details like what is data source?

Is gateway configured is online with proper authetication?

Better do full screenshot of power bi service scheduler page with gateway detail and resource details