Unable to view any visuals - An error occurred while rendering the report

[Baileysa]

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":"{}"}

[v-qiuyu-msft]

Hi @Baileysa,

From your description, it seems that you are able to open the report in Power BI desktop but visuals are not able to loaded, and you are not able to add any new visuals, right?

Please check if you are able to create a new blank report, get data and visualize in visuals. Please clear desktop data cache.

Also please update the Power BI desktop to the latest version 2.56.5023.1021

Best Regards,
Qiuyun Yu

[Baileysa]

Hi, thanks for your reply.

I have already updated to the latest version, this is what caused the problems I'm now having.

I am able to create new reports and connect to data but I'm not able to create any visuals from that data.

I tried to clear the cache as shown above, when i select Options i get this errror...

Feedback Type:
Frown (Error)

Error Message:
Object reference not set to an instance of an object.

Stack Trace:
Error: Object reference not set to an instance of an object.
   at BaseControl.prototype._onViewLoaded (ms-pbi://pbi.microsoft.com/ts/BaseControl.js:176:13)
   at TabPaneControl.prototype._onViewLoaded (ms-pbi://pbi.microsoft.com/ts/TabPaneControl.js:32:13)
   at ReportSettingsTabPaneControl.prototype._onViewLoaded (ms-pbi://pbi.microsoft.com/pbi/Web/ts/FloatingDialog/ReportSettingsTabPaneControl.js:31:13)
   at Anonymous function (ms-pbi://pbi.microsoft.com/ts/BaseControl.js:170:60)
   at Anonymous function (ms-pbi://pbi.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:28218)
   at j (ms-pbi://pbi.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:26852)
   at k.add (ms-pbi://pbi.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:27169)
   at Anonymous function (ms-pbi://pbi.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:28199)
   at each (ms-pbi://pbi.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:2873)
   at Anonymous function (ms-pbi://pbi.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:28145)

Stack Trace Message:
Object reference not set to an instance of an object.

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.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.FloatingDialog.OnError(String message, String stackTrace)
   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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.Mashup.Client.ClientShared.JsExportWrapper.<>c__DisplayClass2.<InvokeMember>b__0()
   at Microsoft.Mashup.Client.ClientShared.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
   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.Windows.MainWindow.InternalShowMachineSettingsDialog()
   at Microsoft.Mashup.Client.Windows.UICommands.CommandActionHandlerBase.CommandAction(UInt32 commandId)
   at Microsoft.Mashup.Client.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)
   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\FrownSnapShot1071217186.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";