Power BI dataset refresh issue

[Rajesh4655TREX]

When i am trying refresh the daraset document in poewrBI . getting below mentioned error.

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":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"vTREXElearninData\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: vTREXElearninData.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 5270a331-ffa9-4353-a025-50367df296db
Request ID: ee32cdaa-e503-1563-0c50-d6c00a6976c0
Time: 2022-08-03 05:41:17Z

[OliT · Accepted solution]

Hi @Rajesh4655TREX 

>> {"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"vTREXElearninData\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: vTREXElearninData.

My suggestion is to open the pbix file in Power BI Desktop, then go to Power Query to open the Advanced Editor, then find the table related to the above message, check which column names in the table have been adjusted, and put the adjusted names Replace the old names.

Regards,

OliT

[SpartaBI]

@Rajesh4655TREX this is the reported reason:

{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},

Looks like your underlying data has changes in such a way that a relaionship broke / wasn't valid anymore. Try check in the PBIX with the new data and look at the power query views if something is broke or some columns that is the one side of the relationship is missing or has now blanks (and didn't have before).

      

Showcase Report – Contoso By SpartaBI