Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've been using power bi for a while and have a few files with visuals I've previously set up, none of these visual will load since I updated on 16/3/18 and I can't create any new visuals either. I've tried running the repair and uninstalling and reinstalling but nothing helps. Here are the full error details..
Feedback Type:
Frown (Error)
JS Error Message:
Cannot read property 'kind' of undefined
Error Message:
An error occurred while rendering the report.
Stack Trace:
TypeError: Cannot read property 'kind' of undefined
at DsrToCategoricalConverter.readData (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4768:149)
at DsrToCategoricalConverter.run (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4670:89)
at Object.categorical (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4649:113)
at ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4413:78
at logTime (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:1772:20)
at generateDataView (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4412:89)
at readDsr (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4386:30)
at Object.read (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:4377:93)
at DsrDataReader.transform (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:217:38)
at DataReaderWrapper.transform (ms-pbi://pbi.microsoft.com/minerva/scripts/data.js:8616:53)
Stack Trace Message:
An error occurred while rendering the report.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Exception exception)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowContainer activeWindow, WindowsHost windowsHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWindowContainer owner)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassa.<Main>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\sarah.bailey\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1474336188.zip
Performance Trace Logs:
C:\Users\sarah.bailey\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
Formulas:
section Section1;
shared outAssetsattemptFLAT = let
Source = Csv.Document(File.Contents("\\buttercup\sharedFolder\ImpactData\outAssetsattemptFLAT.csv"),[Delimiter=";", Columns=25, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"surveyId", Int64.Type}, {"surveyname", type text}, {"surveygroupId", Int64.Type}, {"textualQuestionId", type text}, {"value", type text}, {"Assets", Int64.Type}, {"AssetIndicator", type text}, {"surveyInstanceId", Int64.Type}, {"cMosquito", Int64.Type}, {"cBicycle", Int64.Type}, {"cJewel", Int64.Type}, {"cIron", Int64.Type}, {"cRadio", Int64.Type}, {"cFrying", Int64.Type}, {"cShoes", Int64.Type}, {"cTowel", Int64.Type}, {"cBed", Int64.Type}, {"cMobile", Int64.Type}, {"cWatch", Int64.Type}, {"cClothes", Int64.Type}, {"cMotorcycle", Int64.Type}, {"cTV", Int64.Type}, {"cWheelbarrow", Int64.Type}, {"surveyOrderCompleted", Int64.Type}, {"surveyedLocaleIdentifier", type text}})
in
#"Changed Type";
shared outAssetNormalised = let
Source = Csv.Document(File.Contents("\\buttercup\sharedFolder\ImpactData\outAssetNormalised.csv"),[Delimiter=";", Columns=25, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"surveyId", Int64.Type}, {"surveyname", type text}, {"surveygroupId", Int64.Type}, {"textualQuestionId", type text}, {"value", type text}, {"Assets", Int64.Type}, {"AssetIndicator", type text}, {"surveyInstanceId", Int64.Type}, {"cMosquito", Int64.Type}, {"cBicycle", Int64.Type}, {"cJewel", Int64.Type}, {"cIron", Int64.Type}, {"cRadio", Int64.Type}, {"cFrying", Int64.Type}, {"cShoes", Int64.Type}, {"cTowel", Int64.Type}, {"cBed", Int64.Type}, {"cMobile", Int64.Type}, {"cWatch", Int64.Type}, {"cClothes", Int64.Type}, {"cMotorcycle", Int64.Type}, {"cTV", Int64.Type}, {"cWheelbarrow", Int64.Type}, {"surveyOrderCompleted", Int64.Type}, {"surveyedLocaleIdentifier", type text}})
in
#"Changed Type";
Active Section Contract:
{"id":0,"name":"ReportSection","displayName":"Page 1","filters":"[]","ordinal":0,"visualContainers":[{"x":9.611650485436893,"y":20.09708737864078,"z":1,"width":735.7281553398059,"height":279.6116504854369,"config":"{\"name\":\"9a6fd306f60ac1e4d839\",\"layouts\":[{\"id\":0,\"position\":{\"x\":9.611650485436893,\"y\":20.09708737864078,\"z\":1,\"width\":735.7281553398059,\"height\":279.6116504854369}}],\"singleVisual\":{\"visualType\":\"hundredPercentStackedBarChart\",\"projections\":{\"Category\":[{\"queryRef\":\"outAssetsattemptFLAT.surveyOrderCompleted\",\"active\":true}],\"Y\":[{\"queryRef\":\"CountNonNull(outAssetsattemptFLAT.surveyInstanceId)\"}],\"Series\":[{\"queryRef\":\"outAssetsattemptFLAT.AssetIndicator\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"o\",\"Entity\":\"outAssetsattemptFLAT\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"surveyOrderCompleted\"},\"Name\":\"outAssetsattemptFLAT.surveyOrderCompleted\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"surveyInstanceId\"}},\"Function\":5},\"Name\":\"CountNonNull(outAssetsattemptFLAT.surveyInstanceId)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"AssetIndicator\"},\"Name\":\"outAssetsattemptFLAT.AssetIndicator\"}]},\"objects\":{\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}]}}}","filters":"[]"},{"x":10,"y":320,"z":2,"width":280,"height":280,"config":"{\"name\":\"509d13a38439798604e0\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10,\"y\":320,\"width\":280,\"height\":280,\"z\":2}}],\"singleVisual\":{\"visualType\":\"slicer\",\"projections\":{\"Values\":[{\"queryRef\":\"outAssetsattemptFLAT.surveyOrderCompleted\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"o\",\"Entity\":\"outAssetsattemptFLAT\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"surveyOrderCompleted\"},\"Name\":\"outAssetsattemptFLAT.surveyOrderCompleted\"}]},\"objects\":{\"general\":[{\"properties\":{}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"singleSelect\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}","filters":"[]"},{"x":836.2135922330098,"y":42.81553398058253,"z":3,"width":364.368932038835,"height":280.4854368932039,"config":"{\"name\":\"a2dbf9e306bd7d939579\",\"layouts\":[{\"id\":0,\"position\":{\"x\":836.2135922330098,\"y\":42.81553398058253,\"z\":3,\"width\":364.368932038835,\"height\":280.4854368932039}}],\"singleVisual\":{\"visualType\":\"tableEx\",\"projections\":{\"Values\":[{\"queryRef\":\"outAssetsattemptFLAT.surveyedLocaleIdentifier\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.Assets)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.surveyOrderCompleted)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"o\",\"Entity\":\"outAssetsattemptFLAT\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"surveyedLocaleIdentifier\"},\"Name\":\"outAssetsattemptFLAT.surveyedLocaleIdentifier\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"Assets\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.Assets)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"surveyOrderCompleted\"}},\"Function\":5},\"Name\":\"Sum(outAssetsattemptFLAT.surveyOrderCompleted)\"}]}}}","filters":"[]"},{"x":299.7087378640777,"y":343.39805825242723,"z":4,"width":545.242718446602,"height":279.6116504854369,"config":"{\"name\":\"01819a33069d517bfd6a\",\"layouts\":[{\"id\":0,\"position\":{\"x\":299.7087378640777,\"y\":343.39805825242723,\"z\":4,\"width\":545.242718446602,\"height\":279.6116504854369}}],\"singleVisual\":{\"visualType\":\"clusteredColumnChart\",\"projections\":{\"Y\":[{\"queryRef\":\"Sum(outAssetsattemptFLAT.cBed)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cBicycle)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cClothes)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cFrying)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cIron)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cJewel)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cMobile)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cMosquito)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cMotorcycle)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cRadio)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cShoes)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cTowel)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cTV)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cWatch)\"},{\"queryRef\":\"Sum(outAssetsattemptFLAT.cWheelbarrow)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"o\",\"Entity\":\"outAssetsattemptFLAT\"}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cBed\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cBed)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cBicycle\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cBicycle)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cClothes\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cClothes)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cFrying\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cFrying)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cIron\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cIron)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cJewel\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cJewel)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cMobile\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cMobile)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cMosquito\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cMosquito)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cMotorcycle\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cMotorcycle)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cRadio\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cRadio)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cShoes\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cShoes)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cTowel\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cTowel)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cTV\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cTV)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cWatch\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cWatch)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"o\"}},\"Property\":\"cWheelbarrow\"}},\"Function\":0},\"Name\":\"Sum(outAssetsattemptFLAT.cWheelbarrow)\"}]},\"objects\":{\"categoryAxis\":[{\"properties\":{\"preferredCategoryWidth\":{\"expr\":{\"Literal\":{\"Value\":\"180D\"}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"legend\":[{\"properties\":{\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'Bottom'\"}}}}}]}}}","filters":"[]"}],"displayOption":1,"width":1280,"height":720,"config":"{}"}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.