The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.