Forum Discussion
Power BI dataset refresh issue
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
>> {"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
