An unexpected error occurred (file 'xmvsquery.cpp', line 11083, function XMVSMeasure Validate

[shekhardas]

Feedback Type:
Frown (Error)

Timestamp:
2019-01-16T13:03:17.6827444Z

Local Time:
2019-01-16T07:03:17.6827444-06:00

Session ID:
fd54b38b-85dc-4ab4-930b-1e683c8b85a1

Release:
December 2018

Product Version:
2.65.5313.701 (18.12) (x64)

Error Message:
An unexpected error occurred (file 'xmvsquery.cpp', line 11083, function 'XMVSMeasure::Validate').

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 460798]

Peak Virtual Memory:
34.5 GB

Private Memory:
478 MB

Peak Working Set:
580 MB

IE Version:
11.1446.15063.0

User ID:
b4fac644-3b8c-4c1d-8689-c5d170dd78f6

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\shekhar.das\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot39422531.zip

Performance Trace Logs:
C:\Users\shekhar.das\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared #"PO Product Receipt" = let
Source = AnalysisServices.Databases("USSSSQ09.accudyneindustries.com\Tabular", [TypedMeasureColumns=true, Implementation="2.0"]),
#"Accudyne Vizion360 Purchasing" = Source{[Name="Accudyne Vizion360 Purchasing"]}[Data],
Purchasing1 = #"Accudyne Vizion360 Purchasing"{[Id="Purchasing"]}[Data],
Purchasing2 = Purchasing1{[Id="Purchasing"]}[Data],
#"Added Items" = Cube.Transform(Purchasing2,
{
{Cube.AddAndExpandDimensionColumn, "[Currency Type]", {"[Currency Type].[CurrencyType].[CurrencyType]"}, {"Currency Type.CurrencyType"}},
{Cube.AddAndExpandDimensionColumn, "[Organization Purchasing]", {"[Organization Purchasing].[Business Unit PO].[Business Unit PO]", "[Organization Purchasing].[Organization Code].[Organization Code]", "[Organization Purchasing].[Plant].[Plant]"}, {"Organization Purchasing.Business Unit PO", "Organization Purchasing.Organization Code", "Organization Purchasing.Plant"}},
{Cube.AddAndExpandDimensionColumn, "[PO Receipt Line]", {"[PO Receipt Line].[Intercompany].[Intercompany]", "[PO Receipt Line].[Last Receipt Date].[Last Receipt Date]", "[PO Receipt Line].[Last Receipt Unit Cost].[Last Receipt Unit Cost]", "[PO Receipt Line].[Last Receipt Vendor].[Last Receipt Vendor]", "[PO Receipt Line].[PPV Include Exclude].[PPV Include Exclude]", "[PO Receipt Line].[Receipt Line Status Group].[Receipt Line Status Group]"}, {"PO Receipt Line.Intercompany", "PO Receipt Line.Last Receipt Date", "PO Receipt Line.Last Receipt Unit Cost", "PO Receipt Line.Last Receipt Vendor", "PO Receipt Line.PPV Include Exclude", "PO Receipt Line.Receipt Line Status Group"}},
{Cube.AddAndExpandDimensionColumn, "[Product Branch]", {"[Product Branch].[Commodity Group].[Commodity Group]", "[Product Branch].[Drawing Number].[Drawing Number]", "[Product Branch].[Product Code].[Product Code]", "[Product Branch].[Product Description].[Product Description]", "[Product Branch].[Sub Commodity].[Sub Commodity]"}, {"Product Branch.Commodity Group", "Product Branch.Drawing Number", "Product Branch.Product Code", "Product Branch.Product Description", "Product Branch.Sub Commodity"}},
{Cube.AddAndExpandDimensionColumn, "[Receipt Date]", {"[Receipt Date].[Year].[Year]", "[Receipt Date].[YearsAgo].[YearsAgo]"}, {"Receipt Date.Year", "Receipt Date.YearsAgo"}},
{Cube.AddMeasureColumn, "PO Received Qty", "[Measures].[PO Received Qty]"},
{Cube.AddMeasureColumn, "Received Spend", "[Measures].[Received Spend]"}
}),
#"Filtered Rows" = Table.SelectRows(#"Added Items", each ([Organization Purchasing.Organization Code] = "00300" or [Organization Purchasing.Organization Code] = "00310" or [Organization Purchasing.Organization Code] = "00320" or [Organization Purchasing.Organization Code] = "00330" or [Organization Purchasing.Organization Code] = "00335" or [Organization Purchasing.Organization Code] = "00336" or [Organization Purchasing.Organization Code] = "00337" or [Organization Purchasing.Organization Code] = "00012" or [Organization Purchasing.Organization Code] = "00031" or [Organization Purchasing.Organization Code] = "MR25")),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each (Cube.AttributeMemberId([Currency Type.CurrencyType]) = "[Currency Type].[CurrencyType].&[Corporate]" meta [DisplayName = "Corporate"]) and (Cube.AttributeMemberId([PO Receipt Line.Intercompany]) = "[PO Receipt Line].[Intercompany].&[N]" meta [DisplayName = "N"]) and (Cube.AttributeMemberId([PO Receipt Line.PPV Include Exclude]) = "[PO Receipt Line].[PPV Include Exclude].&[Include]" meta [DisplayName = "Include"]) and (Cube.AttributeMemberId([PO Receipt Line.Receipt Line Status Group]) = "[PO Receipt Line].[Receipt Line Status Group].&[Received PO]" meta [DisplayName = "Received PO"])),
#"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each Cube.AttributeMemberId([Receipt Date.YearsAgo]) = "[Receipt Date].[YearsAgo].&[-1]" meta [DisplayName = "-1"] or Cube.AttributeMemberId([Receipt Date.YearsAgo]) = "[Receipt Date].[YearsAgo].&[0]" meta [DisplayName = "0"] or Cube.AttributeMemberId([Receipt Date.YearsAgo]) = "[Receipt Date].[YearsAgo].&[1]" meta [DisplayName = "1"]),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows2",{"Organization Purchasing.Business Unit PO", "Organization Purchasing.Plant", "PO Receipt Line.Last Receipt Date", "PO Receipt Line.Last Receipt Unit Cost", "PO Receipt Line.Last Receipt Vendor", "Product Branch.Commodity Group", "Product Branch.Drawing Number", "Product Branch.Product Code", "Product Branch.Product Description", "Product Branch.Sub Commodity", "Receipt Date.Year", "PO Received Qty", "Received Spend"}),
#"Unpivoted Only Selected Columns" = Table.Unpivot(#"Removed Other Columns", {"PO Received Qty", "Received Spend"}, "Attribute", "Value"),
#"Inserted Merged Column" = Table.AddColumn(#"Unpivoted Only Selected Columns", "Merged", each Text.Combine({[Receipt Date.Year], [Attribute]}, " "), type text),
#"Removed Columns" = Table.RemoveColumns(#"Inserted Merged Column",{"Receipt Date.Year", "Attribute"}),
#"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Merged]), "Merged", "Value", List.Sum),
#"Filtered Rows3" = Table.SelectRows(#"Pivoted Column", each true)
in
#"Filtered Rows3";

shared Purchasing = let
Source = AnalysisServices.Databases("ussssq09.accudyneindustries.com\tabular", [TypedMeasureColumns=true, Implementation="2.0"]),
#"Accudyne Vizion360 Purchasing" = Source{[Name="Accudyne Vizion360 Purchasing"]}[Data],
Purchasing1 = #"Accudyne Vizion360 Purchasing"{[Id="Purchasing"]}[Data],
Purchasing2 = Purchasing1{[Id="Purchasing"]}[Data],
#"Added Items" = Cube.Transform(Purchasing2,
{
{Cube.AddAndExpandDimensionColumn, "[Product Branch Part List]", {"[Product Branch Part List].[Comments].[Comments]", "[Product Branch Part List].[L1 RFP Date ID].[L1 RFP Date ID]", "[Product Branch Part List].[L1 Stake Rev ID].[L1 Stake Rev ID]", "[Product Branch Part List].[L1 Target Price].[L1 Target Price]", "[Product Branch Part List].[L2 Award Date ID].[L2 Award Date ID]", "[Product Branch Part List].[L2 Award Price].[L2 Award Price]", "[Product Branch Part List].[L2 Frt Diff].[L2 Frt Diff]", "[Product Branch Part List].[L2 Quotes Rec ID].[L2 Quotes Rec ID]", "[Product Branch Part List].[L2 Stake Rev ID].[L2 Stake Rev ID]", "[Product Branch Part List].[L2 Supplier].[L2 Supplier]", "[Product Branch Part List].[L3 Benefit Date ID].[L3 Benefit Date ID]", "[Product Branch Part List].[L3 ERP].[L3 ERP]", "[Product Branch Part List].[L3 Impl Plan].[L3 Impl Plan]", "[Product Branch Part List].[L3 PPAP].[L3 PPAP]", "[Product Branch Part List].[L3 Prod PO].[L3 Prod PO]", "[Product Branch Part List].[Plan L3 Date ID].[Plan L3 Date ID]", "[Product Branch Part List].[Plan Price].[Plan Price]", "[Product Branch Part List].[Plan Units].[Plan Units]", "[Product Branch Part List].[Product Code].[Product Code]", "[Product Branch Part List].[Project Name].[Project Name]", "[Product Branch Part List].[Project Number].[Project Number]", "[Product Branch Part List].[Project Owner].[Project Owner]", "[Product Branch Part List].[Project Type].[Project Type]"}, {"Product Branch Part List.Comments", "Product Branch Part List.L1 RFP Date ID", "Product Branch Part List.L1 Stake Rev ID", "Product Branch Part List.L1 Target Price", "Product Branch Part List.L2 Award Date ID", "Product Branch Part List.L2 Award Price", "Product Branch Part List.L2 Frt Diff", "Product Branch Part List.L2 Quotes Rec ID", "Product Branch Part List.L2 Stake Rev ID", "Product Branch Part List.L2 Supplier", "Product Branch Part List.L3 Benefit Date ID", "Product Branch Part List.L3 ERP", "Product Branch Part List.L3 Impl Plan", "Product Branch Part List.L3 PPAP", "Product Branch Part List.L3 Prod PO", "Product Branch Part List.Plan L3 Date ID", "Product Branch Part List.Plan Price", "Product Branch Part List.Plan Units", "Product Branch Part List.Product Code", "Product Branch Part List.Project Name", "Product Branch Part List.Project Number", "Product Branch Part List.Project Owner", "Product Branch Part List.Project Type"}}
})
in
#"Added Items";

[v-qiuyu-msft]

Hi @shekhardas,

It looks like you are connecting to the SSAS tabular. Is it a SSAS tabular 2017 with CU13 patched? Which action do you perform in Power BI desktop then cause the issue occurs? 

I guess you might meet the issue listed here: https://support.microsoft.com/en-sg/help/4466404/cumulative-update-13-for-sql-server-2017

Best Regards,
Qiuyun Yu 

[AM_BSL]

Hi 

We are facing the same issue -

We are creating a dataset where 1 table is hybrid table (Sales Table) it has relation with CompanyCodes which has relation with User table ( which contains info related to userid and the companies they have access to e.g. user Alex has access to Company 0010,0020,0030)

Dynamic RLS has been implemented as Email = Userprincipalname()

The datamodel is as below-

The end user Alex has viewer role and has read and build permission on dataset

Measure for Salesamount has been created as - Sum(SalesAmount)

While the end user analyze in excel - facing issue when Company Column from Sales table is dragged to  Filter pane of pivot table,

it works fine when multiple values are selected 

but when only one value is selected gives the below error -

We are using Microsoft SQL Server 2019

our full SQL version is