Nullable object must have a value

[Benjamin_chee]

Hi i'm facing an error while loading a query into powerBI.

It keeps throwing the error "Nullable object must have a value"

Would appreciate any help here.

Feedback Type:
Frown (Error)

Timestamp:
2019-06-06T15:04:53.1478307Z

Local Time:
2019-06-06T18:04:53.1478307+03:00

Session ID:
4f848428-6fc2-4851-9d14-9ca71c6d8aee

Release:
May 2019

Product Version:
2.69.5467.2151 (19.05) (x64)

Stack Trace:
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnQualityViewModel.get_ValidFraction()
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnQualityBarRenderer.GetBarViewModels(ColumnQualityViewModel viewModel)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnQualityBarRenderer.Render(IHtmlTextWriter writer, ColumnQualityViewModel viewModel)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnQualityRenderer.Render(IHtmlTextWriter writer, ColumnQualityViewModel columnQualityViewModel, Boolean renderDetails)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnProfileRenderer.RenderColumnQuality(IHtmlTextWriter writer, IReadonlyColumnProfile columnProfile, Int32 columnWidth, Boolean renderColumnQualityDetails)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnProfileRenderer.Render(IHtmlTextWriter writer, Int32 columnIndex, IReadonlyColumnProfile columnProfile, Int32 columnOffset, Int32 columnWidth, Boolean renderColumnQualityDetails, Boolean renderColumnDistribution)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.HtmlTableRenderer.RenderColumnProfiles(IHtmlTextWriter writer, Range columnRange)
at Microsoft.Mashup.Client.UI.Shared.PageManager.HtmlTablePageRenderer.RenderColumnProfilePage(IHtmlTextWriter writer, PageColumn pageColumn, Int32 pageColumnIndex)
at Microsoft.Mashup.Client.UI.Shared.PageManager.HtmlGridPageRenderer.ExecuteWithHtmlWriter(Action`1 renderAction)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Grid.GridResultHtmlControl.JsPageContainerWrapper.AppendPages(PageHtmlProvider pageHtmlProvider, IEnumerable`1 indexesOfPagesToAppend)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Grid.GridResultHtmlControl.JsPageContainerWrapper.UpdatePages(PageHtmlProvider pageHtmlProvider, IEnumerable`1 indexesOfPagesToRemove, IEnumerable`1 indexesOfPagesToAppend, IEnumerable`1 indexesOfPagesToPrepend)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.TableResultHtmlControl.RenderColumnProfilePages(HtmlGridPageRenderer gridPageRenderer, GridPages gridPagesToRender, GridPageDiffs gridPageDiffs)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.TableResultHtmlControl.OnProfileCompleted(Object sender, ProfileComputedEventArgs eventArgs)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at Microsoft.Mashup.Host.Models.EventHandlerExtensions.RaiseEvent[TEventArgs](EventHandler`1 handler, Object sender, TEventArgs args)
at Microsoft.Mashup.Client.UI.Shared.Models.Profiling.TableProfileEvaluator.TableProfileEvaluationRunner.OnEvaluationCompleted(ITableProfileEvaluation currentEvaluation, IEnumerable`1 computedColumnProfiles)
at Microsoft.Mashup.Client.UI.Shared.Models.Profiling.Evaluations.TableProfileEvaluationBase.OnEvaluationCompleted(PreviewReference previewReference, Action`1 completedCallback, Action failedCallback)
at Microsoft.Mashup.Host.Document.Evaluation.PreviewEvaluationQueue.<>c__DisplayClass48_0.<OnPreviewComplete>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

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

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

Peak Virtual Memory:
37.9 GB

Private Memory:
412 MB

Peak Working Set:
578 MB

IE Version:
11.799.17134.0

User ID:
5da56ad8-55be-4bad-bcd7-1bf8d8869e4f

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

Telemetry Enabled:
True

Model Default Mode:
Empty

Snapshot Trace Logs:
C:\Users\Yong Zhun Hung\Microsoft\Power BI Desktop Store App\FrownSnapShot532086998.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_improvedFilterExperience
PBI_qnaLiveConnect
PBI_keyDrivers

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-qiuyu-msft]

Hi @Benjamin_chee, 

Is it possible for you to share the Power Query of this problematic query? 

Also you can take a look at this similar thread: https://community.powerbi.com/t5/Desktop/quot-Nullable-Object-must-have-a-value-quot-Error-while-cre...

Best Regards,
Qiuyun Yu 

[Benjamin_chee]

Hi @v-qiuyu-msft ,

This is the query.

let startdatetime  = todatetime("2019-06-05");
let endDatetime = now();
Audit
| where CreatedTime between (startdatetime.. endDatetime)
| where ActionName == 'download'
| extend ExtProps=todynamic(CustomDimensions)
| where Trigger != 'Unknow'
| project CreatedTime, UserGroupID, UserAliasID, SystemID, ActionName, Trigger, ChangedObject, ExtProps.objectId, ExtProps.source

[v-qiuyu-msft]

Hi @Benjamin_chee, 

The query you posted is kusto query. Please share the Power Query, you can go to Query Editor, select the query, then click on Advanced Editor to get it. 

Best Regards,
Qiuyun Yu