Forum Discussion

AUaero's avatar
AUaero
Responsive Resident
7 years ago
Solved

Error when filtering visual after moving tabular model from test server to production

Hi,   I've got a Power BI report that is connected to a tabular model running on my test server.  Everything works fine here.  I scripted the tabular model and deployed via script to my production ...
Need Help
AUaero's avatar
AUaero
Responsive Resident
7 years ago

This is the trace that is generated when the error occurs:

 

ObjectCacheSessions/Data/CacheStats/Size {"Start":"2019-02-25T17:08:24.2952529Z","Action":"ObjectCacheSessions/Data/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":153356,"Tid":22,"Duration":"00:00:00.0020939"}
ObjectCacheSessions/Data/CacheStats/Access {"Start":"2019-02-25T17:08:24.2999693Z","Action":"ObjectCacheSessions/Data/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":153356,"Tid":22,"Duration":"00:00:00.0000609"}

AUaero's avatar
AUaero
Responsive Resident
7 years ago

This is from the detailed trace after I enabled tracing - I'm thinking this is the relative part since iserror = true for some of these lines of the log:

 

DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:29.7720000Z","Action":"PBI.Visual.ApiUsage","parentId":"","errorSource":"User","activityName":"PBI.Dashboard.RootSession","activityId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","start":"2019-02-26T21:44:29.755Z","end":"2019-02-26T21:44:29.772Z","name":"filterSlicer","custom":"false","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"3922529a-49dd-5fbf-79ec-76b5cf675eac","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:30.7910577"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:29.7520000Z","Action":"PBI.Visual.Load","parentId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","activityName":"PBI.Dashboard.RootSession","activityId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","visualType":"filterSlicer","hostInformation":"{\"name\":\"Exploration\"}","end":"2019-02-26T21:44:29.773Z","duration":"0 - 100ms","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"c5d35813-083d-2b54-4d22-29c86c480cd9","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:30.8110794"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:31.3380000Z","Action":"PBI.Data.ExecuteQuery","parentId":"","isError":"true","errorSource":"PowerBI","errorCode":"QuerySystemError","activityName":"PBI.EX.VisualContainerApplyUpdate","activityId":"ed37461a-36d1-011b-c3ab-41d07a5aad59","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"1260ecae-ef63-db16-2962-c9630c8aa5a6","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:29.2250970"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:31.3390000Z","Action":"PBI.Data.ExecuteQuery","parentId":"","isError":"true","errorSource":"PowerBI","errorCode":"QuerySystemError","activityName":"PBI.EX.VisualContainerApplyUpdate","activityId":"ed37461a-36d1-011b-c3ab-41d07a5aad59","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"37009dcb-c4d4-fbd4-edfe-cf2fe2f78f4d","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:29.2241879"}
DataMashup.Trace Critical: 24579 : {"Start":"2019-02-26T21:44:31.3390000Z","Action":"PBI.Visual.Error","errorCode":"QuerySystemError","targetVisualType":"tableEx","debugErrorInfo":"","message":"Can't display the visual.","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"921cc57a-a62e-7ac0-6b8a-eda1aa8afce9","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:29.2242051"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-02-26T21:44:31.2250000Z","Action":"PBI.EX.FilterPaneBasicFilterChanged","parentId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","activityName":"PBI.Dashboard.RootSession","activityId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","filterScopeType":"Visual","fieldKind":"ColumnRef","viewMode":"Edit","end":"2019-02-26T21:44:31.339Z","duration":"100 - 200ms","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"fde09991-a134-381b-132f-0a037696a685","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:29.3384552"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:34.8280000Z","Action":"PBI.Data.GetConceptualSchema","parentId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","activityName":"PBI.Dashboard.RootSession","activityId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","endPoint":"","clientAndServerRequestIdMatch":"true","responseRequestId":"","datasetIds":"[1]","asErrorCode":"","requestId":"","end":"2019-02-26T21:44:34.972Z","duration":"100 - 200ms","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"6ed82b6e-b74e-8dbb-ec0e-84c0365fafe3","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:25.7354784"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:35.1870000Z","Action":"PBI.Visual.ApiUsage","parentId":"","errorSource":"User","activityName":"PBI.EX.RenderExplorationVisual","activityId":"ee6ec809-bb6f-0bd3-4e21-b73d198cda9d","start":"2019-02-26T21:44:35.170Z","end":"2019-02-26T21:44:35.187Z","name":"filterSlicer","custom":"false","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"4f3f1821-6240-ec0e-ba52-55fb17ef5241","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:25.3764956"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:35.1670000Z","Action":"PBI.Visual.Load","parentId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","activityName":"PBI.EX.RenderExplorationVisual","activityId":"ee6ec809-bb6f-0bd3-4e21-b73d198cda9d","visualType":"filterSlicer","hostInformation":"{\"name\":\"Exploration\"}","end":"2019-02-26T21:44:35.188Z","duration":"0 - 100ms","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"6bb876d1-c447-0346-dfb1-fd1d6cec88dc","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:25.3965123"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:35.1950000Z","Action":"PBI.Data.ExecuteQuery","parentId":"","isError":"true","errorSource":"PowerBI","errorCode":"QuerySystemError","activityName":"PBI.EX.RenderExplorationVisual","activityId":"ee6ec809-bb6f-0bd3-4e21-b73d198cda9d","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"04eb1521-2edb-86ec-7d04-53e99bc6ebb8","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:25.3685731"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:44:35.1950000Z","Action":"PBI.Data.ExecuteQuery","parentId":"","isError":"true","errorSource":"PowerBI","errorCode":"QuerySystemError","activityName":"PBI.EX.RenderExplorationVisual","activityId":"ee6ec809-bb6f-0bd3-4e21-b73d198cda9d","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"044fe501-7c5d-1935-ac13-13e87c90fd2d","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:25.3685912"}
DataMashup.Trace Critical: 24579 : {"Start":"2019-02-26T21:44:35.1950000Z","Action":"PBI.Visual.Error","errorCode":"QuerySystemError","targetVisualType":"tableEx","debugErrorInfo":"","message":"Can't display the visual.","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"49e2ce00-c96a-ec97-77e1-2ab53cd048c2","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:25.3686062"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-02-26T21:44:39.4800000Z","Action":"PBI.EX.FilterPaneBasicFilterChanged","parentId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","activityName":"PBI.Dashboard.RootSession","activityId":"90d04fd1-f230-c3ba-62c7-9abc62cb4a53","filterScopeType":"Visual","fieldKind":"ColumnRef","viewMode":"Edit","end":"2019-02-26T21:44:39.562Z","duration":"0 - 100ms","buildType":"release","minervaBuild":"11.0.0206.013607","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"f409e362-d63d-77f9-add5-2e0f3d2037ee","Process":"PBIDesktop","Pid":17516,"Tid":32,"Duration":"00:00:21.0836251"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-02-26T21:45:09.1728632Z","Action":"PBI.PQ.RibbonButton","activeView":"Reports","actionId":"MultiArtifactButtonReportRefreshReport","parentId":"df08ff6e-9bfa-47f5-a4c1-672b8308fe74","isError":"False","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"72c5f21d-2613-4f9a-a843-b09c82984abe","Process":"PBIDesktop","Pid":17516,"Tid":1,"Duration":"00:00:00.0139410"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-02-26T21:45:09.1748692Z","Action":"PBI.CommandExecute","commandName":"RefreshAllQueriesCommand","parentId":"parentId","isError":"False","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"ec1c3486-e052-406a-863f-d7109ff1ced0","Process":"PBIDesktop","Pid":17516,"Tid":1,"Duration":"00:00:00.0129116"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:45:09.1951751Z","Action":"PackageSessionStorage/GetSessionStorage","PackageReference":[["300f6965-e00c-4089-9ab1-9d047bcde7a6"],[3]],"ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17516,"Tid":1,"Duration":"00:00:00.0000223"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:45:09.1951932Z","Action":"PackageStorage/Access","PackageReference":[["300f6965-e00c-4089-9ab1-9d047bcde7a6"],[3]],"ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17516,"Tid":1,"Duration":"00:00:00.0002925"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:45:09.3382742Z","Action":"PackageSessionStorage/GetSessionStorage","PackageReference":[["300f6965-e00c-4089-9ab1-9d047bcde7a6"],[3]],"ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17516,"Tid":19,"Duration":"00:00:00.0000270"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:45:09.3382968Z","Action":"PackageStorage/Access","PackageReference":[["300f6965-e00c-4089-9ab1-9d047bcde7a6"],[3]],"ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17516,"Tid":19,"Duration":"00:00:00.0003085"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-02-26T21:45:09.4918709Z","Action":"PBI.Win.DuplicateKeyAddedToModelCache","parentId":"0","isError":"False","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"3fc3e1ab-6b87-45a2-84d1-0e8aa188903f","Process":"PBIDesktop","Pid":17516,"Tid":18,"Duration":"00:00:00.0125553"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:45:09.5044262Z","Action":"PBI.TraceMessage","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","Message":"Generating DataShape for: <pi>{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"o\",\"Entity\":\"OSR_HIERARCHY\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"OSR_NAME\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'BAILEY, CHAD E'\"}}]]}}}],\"OrderBy\":[],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"OSR_NAME\"},\"Name\":\"OSR_HIERARCHY.OSR_NAME\"}],\"GroupBy\":[]},\"Binding\":{\"Version\":1,\"Primary\":{\"Groupings\":[{\"Projections\":[0],\"Subtotal\":1}]},\"DataReduction\":{\"Primary\":{\"Window\":{\"Count\":500}},\"DataVolume\":3}}}</pi>","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17516,"Tid":19,"Duration":"00:00:00.0000214"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-26T21:45:09.5047170Z","Action":"PBI.TraceMessage","sessionId":"970c3cfb-d091-4f10-90c0-a77259db9aec","deviceId":"18165eee","userId":"9103bbfb-5372-4215-9dfd-2577f33b6ae0","isInternal":"False","authenticatedUserId":"66114fb9-31e4-41c1-8b7c-9ac1e3df45d0","Message":"Generated DataShape: <pi>{\"Id\":\"DS0\",\"PrimaryHierarchy\":{\"DataMembers\":[{\"Id\":\"DM0\",\"Group\":{\"GroupKeys\":[{\"Value\":\"Sandbox.OSR_HIERARCHY\\u002fOSR_NAME\"}],\"SortKeys\":[{\"Value\":\"Sandbox.OSR_HIERARCHY\\u002fOSR_NAME\",\"SortDirection\":\"Ascending\"}]},\"Calculations\":[{\"Id\":\"G0\",\"Value\":\"Sandbox.OSR_HIERARCHY\\u002fOSR_NAME\"}]}]},\"Filters\":[{\"Target\":\"[DS0]\",\"Condition\":{\"Type\":\"FilterEmptyGroups\"}},{\"Target\":\"[DS0]\",\"Condition\":{\"Type\":\"In\",\"Expressions\":[\"Sandbox.OSR_HIERARCHY\\u002fOSR_NAME\"],\"Values\":[[\"\\u0027BAILEY, CHAD E\\u0027\"]]}}],\"RequestedPrimaryLeafCount\":500,\"IncludeRestartTokens\":true}</pi>","ProductVersion":"2.66.5376.2521 (19.02)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17516,"Tid":19,"Duration":"00:00:00.0000120"}
DataMashup.Trace Information: 24579 : {"Start":"2019-02-