Forum Discussion

xiumi_hou's avatar
xiumi_hou
Icon for Post Partisan rankPost Partisan
6 years ago
Solved

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

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 ,

    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.

5 Replies

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

     

    • xiumi_hou's avatar
      xiumi_hou
      Icon for Post Partisan rankPost 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's avatar
        jdbuchanan71
        Icon for Super User rankSuper User

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

         

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity 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 Li

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