Forum Discussion
Urgent - refresh not working
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
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
2 Replies
- AnonymousNot applicable
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
- v-xuding-msftCommunity Support
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