Forum Discussion
Urgent Need help - Something gent wrong (Not sure where)
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 ,
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- jdbuchanan71
Super User
Does your gateway have access / permission to the new data sources?
- xiumi_hou
Post Partisan
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
Super User
Check under the data source credentials, it's the only thing I can think of.
- v-yingjl
Community Support
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.