Expression Error : The key didn't match any rows in the table

[Anonymous]

I have a Power BI report when i'm refreshing the report I'm getting below error :

Key Not Match Error

I have edited my datasource by adding same credentials and try to refresh I'm getting below error :

Sales
Column 'Actual Gross Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Cost of Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Cost of Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Discount Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Net Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Profit Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Profit Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Budget Gross Profit Amt' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Qty Ordered In Kg' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Budget Gross Sales Amt' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Cost of Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Budget Cost Of Sales Amt' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Qty Ordered In Kg' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Budget Qty Ordered In Kg' in table 'Sales' cannot be found or may not be used in this expression. -
Column 'Actual Gross Profit Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Budget Gross Profit Amt' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Gross Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Cost of Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Cost of Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Cost of Sales Amt MUR' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Qty Ordered In Kg' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Qty Ordered In Kg' in table 'Sales' cannot be found or may not be used in this expression. 
Column 'Actual Qty Ordered In Kg' in table 'Sales' cannot be found or may not be used in this expression. 
OLE DB or ODBC error: [DataSource.Error] AnalysisServices: Server: 
The operation has been cancelled because there is not enough memory available for the application. 
If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine..
DIM_Dates
Load was cancelled by an error in loading a previous table.

Those missing column are present in my Adavanced Editor Query.

Below are my Advanced Editor Query.

let
    Source = AnalysisServices.Databases("nesdwsqlclst.eclosiagroup.mu", [TypedMeasureColumns=true, Implementation="2.0"]),
    #"Sales Cube" = Source{[Name="Sales Cube"]}[Data],
    Sales1 = #"Sales Cube"{[Id="Sales"]}[Data],
    Sales2 = Sales1{[Id="Sales"]}[Data],
    #"Added Items" = Cube.Transform(Sales2,
        {
            {Cube.AddAndExpandDimensionColumn, "[Business Unit Dimension]", {"[Business Unit Dimension].[Business Unit Code].[Business Unit Code]", "[Business Unit Dimension].[Business Unit Name].[Business Unit Name]"}, {"Business Unit Dimension.Business Unit Code", "Business Unit Dimension.Business Unit Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Company Dimension]", {"[Company Dimension].[Company Code].[Company Code]", "[Company Dimension].[Company Name].[Company Name]"}, {"Company Dimension.Company Code", "Company Dimension.Company Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Customer Dimension]", {"[Customer Dimension].[Customer Code].[Customer Code]", "[Customer Dimension].[Customer Name].[Customer Name]"}, {"Customer Dimension.Customer Code", "Customer Dimension.Customer Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Customer Mini Dimension]", {"[Customer Mini Dimension].[Address].[Address]", "[Customer Mini Dimension].[Chain Code].[Chain Code]", "[Customer Mini Dimension].[Chain Desc].[Chain Desc]", "[Customer Mini Dimension].[Channel Code].[Channel Code]", "[Customer Mini Dimension].[Channel Desc].[Channel Desc]", "[Customer Mini Dimension].[Classification Group].[Classification Group]", "[Customer Mini Dimension].[Contact Number].[Contact Number]", "[Customer Mini Dimension].[Country Code].[Country Code]", "[Customer Mini Dimension].[Country Desc].[Country Desc]", "[Customer Mini Dimension].[Currency].[Currency]", "[Customer Mini Dimension].[Line Of Business].[Line Of Business]", "[Customer Mini Dimension].[Mode of Payment Code].[Mode of Payment Code]", "[Customer Mini Dimension].[Mode of Payment Desc].[Mode of Payment Desc]", "[Customer Mini Dimension].[Region Code].[Region Code]", "[Customer Mini Dimension].[Region Desc].[Region Desc]", "[Customer Mini Dimension].[Sales Group Code].[Sales Group Code]", "[Customer Mini Dimension].[Sales Group Desc].[Sales Group Desc]", "[Customer Mini Dimension].[Sponsorship Type Code].[Sponsorship Type Code]", "[Customer Mini Dimension].[Sponsorship Type Desc].[Sponsorship Type Desc]", "[Customer Mini Dimension].[State].[State]", "[Customer Mini Dimension].[Statistics Group].[Statistics Group]", "[Customer Mini Dimension].[Status Code].[Status Code]", "[Customer Mini Dimension].[Status Desc].[Status Desc]", "[Customer Mini Dimension].[Tax Group Code].[Tax Group Code]", "[Customer Mini Dimension].[Tax Group Desc].[Tax Group Desc]", "[Customer Mini Dimension].[Terms of Payment Code].[Terms of Payment Code]", "[Customer Mini Dimension].[Terms of Payment Desc].[Terms of Payment Desc]"}, {"Customer Mini Dimension.Address", "Customer Mini Dimension.Chain Code", "Customer Mini Dimension.Chain Desc", "Customer Mini Dimension.Channel Code", "Customer Mini Dimension.Channel Desc", "Customer Mini Dimension.Classification Group", "Customer Mini Dimension.Contact Number", "Customer Mini Dimension.Country Code", "Customer Mini Dimension.Country Desc", "Customer Mini Dimension.Currency", "Customer Mini Dimension.Line Of Business", "Customer Mini Dimension.Mode of Payment Code", "Customer Mini Dimension.Mode of Payment Desc", "Customer Mini Dimension.Region Code", "Customer Mini Dimension.Region Desc", "Customer Mini Dimension.Sales Group Code", "Customer Mini Dimension.Sales Group Desc", "Customer Mini Dimension.Sponsorship Type Code", "Customer Mini Dimension.Sponsorship Type Desc", "Customer Mini Dimension.State", "Customer Mini Dimension.Statistics Group", "Customer Mini Dimension.Status Code", "Customer Mini Dimension.Status Desc", "Customer Mini Dimension.Tax Group Code", "Customer Mini Dimension.Tax Group Desc", "Customer Mini Dimension.Terms of Payment Code", "Customer Mini Dimension.Terms of Payment Desc"}},
            {Cube.AddAndExpandDimensionColumn, "[Date Dimension]", {"[Date Dimension].[Cal Month Desc].[Cal Month Desc]", "[Date Dimension].[Cal Quarter Desc].[Cal Quarter Desc]", "[Date Dimension].[Cal Week Desc].[Cal Week Desc]", "[Date Dimension].[Cal Year Desc].[Cal Year Desc]", "[Date Dimension].[Date Desc].[Date Desc]", "[Date Dimension].[Date Id].[Date Id]", "[Date Dimension].[Fin Month Desc].[Fin Month Desc]", "[Date Dimension].[Fin Quarter Desc].[Fin Quarter Desc]", "[Date Dimension].[Fin Year Desc].[Fin Year Desc]", "[Date Dimension].[Trans Date].[Trans Date]"}, {"Date Dimension.Cal Month Desc", "Date Dimension.Cal Quarter Desc", "Date Dimension.Cal Week Desc", "Date Dimension.Cal Year Desc", "Date Dimension.Date Desc", "Date Dimension.Date Id", "Date Dimension.Fin Month Desc", "Date Dimension.Fin Quarter Desc", "Date Dimension.Fin Year Desc", "Date Dimension.Trans Date"}},
            {Cube.AddAndExpandDimensionColumn, "[Department Dimension]", {"[Department Dimension].[Department Code].[Department Code]", "[Department Dimension].[Department Name].[Department Name]"}, {"Department Dimension.Department Code", "Department Dimension.Department Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Order Num Dimension]", {"[Order Num Dimension].[Order Num].[Order Num]"}, {"Order Num Dimension.Order Num"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Brand Dimension]", {"[Product Brand Dimension].[Product Brand Code].[Product Brand Code]", "[Product Brand Dimension].[Product Brand Description].[Product Brand Description]"}, {"Product Brand Dimension.Product Brand Code", "Product Brand Dimension.Product Brand Description"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Category L1 Dimension]", {"[Product Category L1 Dimension].[Product Category L1 Code].[Product Category L1 Code]", "[Product Category L1 Dimension].[Product Category L1 Name].[Product Category L1 Name]"}, {"Product Category L1 Dimension.Product Category L1 Code", "Product Category L1 Dimension.Product Category L1 Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Category L2 Dimension]", {"[Product Category L2 Dimension].[Product Category L2 Code].[Product Category L2 Code]", "[Product Category L2 Dimension].[Product Category L2 Name].[Product Category L2 Name]"}, {"Product Category L2 Dimension.Product Category L2 Code", "Product Category L2 Dimension.Product Category L2 Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Category L3 Dimension]", {"[Product Category L3 Dimension].[Product Category L3 Code].[Product Category L3 Code]", "[Product Category L3 Dimension].[Product Category L3 Name].[Product Category L3 Name]"}, {"Product Category L3 Dimension.Product Category L3 Code", "Product Category L3 Dimension.Product Category L3 Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Category L4 Dimension]", {"[Product Category L4 Dimension].[Product Category L4 Code].[Product Category L4 Code]", "[Product Category L4 Dimension].[Product Category L4 Name].[Product Category L4 Name]"}, {"Product Category L4 Dimension.Product Category L4 Code", "Product Category L4 Dimension.Product Category L4 Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Category L5 Dimension]", {"[Product Category L5 Dimension].[Product Category L5 Code].[Product Category L5 Code]", "[Product Category L5 Dimension].[Product Category L5 Name].[Product Category L5 Name]"}, {"Product Category L5 Dimension.Product Category L5 Code", "Product Category L5 Dimension.Product Category L5 Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Dimension]", {"[Product Dimension].[Product Code].[Product Code]", "[Product Dimension].[Product Name].[Product Name]"}, {"Product Dimension.Product Code", "Product Dimension.Product Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Group Dimension]", {"[Product Group Dimension].[Product Group Code].[Product Group Code]", "[Product Group Dimension].[Product Group Name].[Product Group Name]"}, {"Product Group Dimension.Product Group Code", "Product Group Dimension.Product Group Name"}},
            {Cube.AddAndExpandDimensionColumn, "[Product Statistical Dimension]", {"[Product Statistical Dimension].[Statistical Code 1].[Statistical Code 1]", "[Product Statistical Dimension].[Statistical Code 2].[Statistical Code 2]", "[Product Statistical Dimension].[Statistical Code 3].[Statistical Code 3]", "[Product Statistical Dimension].[Statistical Code 4].[Statistical Code 4]", "[Product Statistical Dimension].[Statistical Code 5].[Statistical Code 5]", "[Product Statistical Dimension].[Statistical Description 1].[Statistical Description 1]", "[Product Statistical Dimension].[Statistical Description 2].[Statistical Description 2]", "[Product Statistical Dimension].[Statistical Description 3].[Statistical Description 3]", "[Product Statistical Dimension].[Statistical Description 4].[Statistical Description 4]", "[Product Statistical Dimension].[Statistical Description 5].[Statistical Description 5]", "[Product Statistical Dimension].[Unit of Measure].[Unit of Measure]"}, {"Product Statistical Dimension.Statistical Code 1", "Product Statistical Dimension.Statistical Code 2", "Product Statistical Dimension.Statistical Code 3", "Product Statistical Dimension.Statistical Code 4", "Product Statistical Dimension.Statistical Code 5", "Product Statistical Dimension.Statistical Description 1", "Product Statistical Dimension.Statistical Description 2", "Product Statistical Dimension.Statistical Description 3", "Product Statistical Dimension.Statistical Description 4", "Product Statistical Dimension.Statistical Description 5", "Product Statistical Dimension.Unit of Measure"}},
            {Cube.AddMeasureColumn, "Actual Cost of  Sales Amt FCY", "[Measures].[Actual Cost of  Sales Amt FCY]"},
            {Cube.AddMeasureColumn, "Actual Cost of Sales Amt MUR", "[Measures].[Actual Cost of Sales Amt MUR]"},
            {Cube.AddMeasureColumn, "Actual Discount Amt FCY", "[Measures].[Actual Discount Amt FCY]"},
            {Cube.AddMeasureColumn, "Actual Discount Amt MUR", "[Measures].[Actual Discount Amt MUR]"},
            {Cube.AddMeasureColumn, "Actual Gross Profit Amt FCY", "[Measures].[Actual Gross Profit Amt FCY]"},
            {Cube.AddMeasureColumn, "Actual Gross Profit Amt MUR", "[Measures].[Actual Gross Profit Amt MUR]"},
            {Cube.AddMeasureColumn, "Actual Gross Sales Amt FCY", "[Measures].[Actual Gross Sales Amt FCY]"},
            {Cube.AddMeasureColumn, "Actual Gross Sales Amt MUR", "[Measures].[Actual Gross Sales Amt MUR]"},
            {Cube.AddMeasureColumn, "Actual Net Sales Amt FCY", "[Measures].[Actual Net Sales Amt FCY]"},
            {Cube.AddMeasureColumn, "Actual Net Sales Amt MUR", "[Measures].[Actual Net Sales Amt MUR]"},
            {Cube.AddMeasureColumn, "Actual Qty Invoiced", "[Measures].[Actual Qty Invoiced]"},
            {Cube.AddMeasureColumn, "Actual Qty Invoiced In Kg", "[Measures].[Actual Qty Invoiced In Kg]"},
            {Cube.AddMeasureColumn, "Actual Qty Ordered", "[Measures].[Actual Qty Ordered]"},
            {Cube.AddMeasureColumn, "Actual Qty Ordered In Kg", "[Measures].[Actual Qty Ordered In Kg]"},
            {Cube.AddMeasureColumn, "Actual Qty Returned", "[Measures].[Actual Qty Returned]"},
            {Cube.AddMeasureColumn, "Actual Qty Returned In Kg", "[Measures].[Actual Qty Returned In Kg]"},
            {Cube.AddMeasureColumn, "Actual Qty Shipped", "[Measures].[Actual Qty Shipped]"},
            {Cube.AddMeasureColumn, "Actual Qty Shipped In Kg", "[Measures].[Actual Qty Shipped In Kg]"},
            {Cube.AddMeasureColumn, "Budget Sales Amt Exc Vat", "[Measures].[Budget Sales Amt Exc Vat]"},
            {Cube.AddMeasureColumn, "Budget Sales Amt Inc Vat", "[Measures].[Budget Sales Amt Inc Vat]"},
            {Cube.AddMeasureColumn, "Budget Sales Qty", "[Measures].[Budget Sales Qty]"},
            {Cube.AddMeasureColumn, "Budget Sales Qty in Kg", "[Measures].[Budget Sales Qty in Kg]"},
            {Cube.AddMeasureColumn, "Forecast Cost Of Sales Amt", "[Measures].[Forecast Cost Of Sales Amt]"},
            {Cube.AddMeasureColumn, "Forecast Gross Sales Amt", "[Measures].[Forecast Gross Sales Amt]"},
            {Cube.AddMeasureColumn, "Forecast Qty Ordered", "[Measures].[Forecast Qty Ordered]"},
            {Cube.AddMeasureColumn, "Forecast Qty Ordered in Kg", "[Measures].[Forecast Qty Ordered in Kg]"},
            {Cube.AddMeasureColumn, "Forecast Sales Amt Exc VAT", "[Measures].[Forecast Sales Amt Exc VAT]"},
            {Cube.AddMeasureColumn, "Forecast Sales Amt Inc VAT", "[Measures].[Forecast Sales Amt Inc VAT]"},
            {Cube.AddMeasureColumn, "Value Invoiced Exc VAT FCY", "[Measures].[Value Invoiced Exc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Invoiced Exc VAT MUR", "[Measures].[Value Invoiced Exc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Invoiced Inc VAT FCY", "[Measures].[Value Invoiced Inc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Invoiced Inc VAT MUR", "[Measures].[Value Invoiced Inc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Ordered Exc VAT FCY", "[Measures].[Value Ordered Exc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Ordered Exc VAT MUR", "[Measures].[Value Ordered Exc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Ordered Inc VAT FCY", "[Measures].[Value Ordered Inc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Ordered Inc VAT MUR", "[Measures].[Value Ordered Inc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Returned Exc VAT FCY", "[Measures].[Value Returned Exc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Returned Exc VAT MUR", "[Measures].[Value Returned Exc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Returned Inc VAT FCY", "[Measures].[Value Returned Inc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Returned Inc VAT MUR", "[Measures].[Value Returned Inc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Shipped Exc VAT FCY", "[Measures].[Value Shipped Exc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Shipped Exc VAT MUR", "[Measures].[Value Shipped Exc VAT MUR]"},
            {Cube.AddMeasureColumn, "Value Shipped Inc VAT FCY", "[Measures].[Value Shipped Inc VAT FCY]"},
            {Cube.AddMeasureColumn, "Value Shipped Inc VAT MUR", "[Measures].[Value Shipped Inc VAT MUR]"}
        })
in
    #"Added Items"

Can someone help about how I can solved this issue.

I'm currently stuck with this problem and don't know how to resolve it.

[v-eachen-msft]

Hi @Anonymous ,

1. Click home --> edit queries

2. Under applied steps, remove navigation
3. Click "close and apply" and check if it works.

You could also refer to this case:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/m-p/155986

[Anonymous]

I'm getting the following errors when removing the navigation step.

The value is not a cube.

Value is not a cube