Power BI Dataset not refreshing suddenly.

[Anonymous]

Hi,

I am getting below message when try to refersh the dataset.

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":"Microsoft SQL: Invalid column name 'SLNX'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"16"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"uk1sxwnsql0084;Print_Statistics"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Invalid column name 'SLNX'."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"207"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: SNOW check.
Cluster URI: WABI-US-NORTH-CENTRAL-F-PRIMARY-redirect.analysis.windows.net
Activity ID: 2a7e5c38-3fee-4cf6-9748-d4e439b295d7
Request ID: 4d5889f3-0f46-021f-c87a-0c00cfdb4cae
Time: 2021-04-28 11:29:12Z

[ibarrau]

Hi. You have to open the origin to fix it. Look for the file.pbix of the dataset and check Power Query code (the same error should occur when refresh in desktop). The error says "Microsoft SQL: Invalid column name 'SLNX'." This means that you have a step in Power Query like for example change type referencing a column with the name of SLNX that is not longer in the Source. You can go clikcing one by one the steps to find where it is breaking.

Check it out and let us know how it goes.

I hope that helps,