Direct Query and Custom Date Table

[Anonymous]

As soon as I created a new date table, I can no longer save the file. I recieve two respective errors (with CANCEL on first error). I can produce this result each and every time by repeating same action.

Feedback Type:
Frown (Error)

Timestamp:
2019-02-08T22:04:36.7269555Z

Local Time:
2019-02-08T16:04:36.7269555-06:00

Session ID:
6f776ba0-abb7-48ef-958c-e7e39fa0ea39

Release:
December 2018

Product Version:
2.65.5313.1381 (18.12) (x64)

Stack Trace:
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.PowerBI.Modeler.ModelManager.SaveChanges(String description)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<Commit>b__28()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit()
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ExtendedModelChangeScopeBase.ExecuteChange(ModelChange modelChange, Boolean saveChange)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IAnalysisServicesDatabase analysisServicesDatabase, IModelManager modelManager, Boolean requireASDBToBeUnattached)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.RunOutOfBandExtendedModelChangeCore(Action`1 extendedModelChange, Boolean requireASDBToBeUnattached)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.SanitizeDataModel(Action saveAction)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.SaveToPbix(String filePath, Uri dataModelPath)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Save(Report report, FileStream fileStream, DataModelSaveMode dataModelSaveMode, Queries queries)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.SaveToTempFile(Boolean forceModelDirty, Boolean forceStreamSave)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<TrySaveBIPackage>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<TrySaveFile>d__c.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClassa`1.<<BlockUIAndRun>b__9>d__c.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.ShowGenericFileSaveUIAndWait(IPowerBIWindowService windowService, IPbixFile pbixFile, Func`2 performSaveMethod)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.TrySaveFile[T](IReportDocumentProvider reportDocumentProvider, IDiagramLayoutProvider diagramLayoutProvider, IPowerBIWindowService windowService, IQueryServices queryServices, TelemetryUserActionId entryPoint, Func`3 promptForFileMethod, Func`4 showSaveUIAndWaitMethod, Boolean saveAsNewFile, T saveAsFile, Boolean saveAsPbixOnly)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.TrySaveFile(IReportDocumentProvider reportDocumentProvider, IDiagramLayoutProvider diagramLayoutProvider, IPowerBIWindowService windowService, IQueryServices queryServices, TelemetryUserActionId entryPoint, Boolean saveAsPbixOnly)
at Microsoft.PowerBI.Client.Windows.Ribbon.ApplicationRibbonCommandActionHandler.HandleCommand(UInt32 commandId)
at Microsoft.Mashup.Client.UI.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)

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

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

Peak Virtual Memory:
38.1 GB

Private Memory:
368 MB

Peak Working Set:
515 MB

IE Version:
11.165.17134.0

User ID:
3347cb63-20cd-4e3d-87e5-bec1e243df08

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

Telemetry Enabled:
True

Model Default Mode:
Composite

Snapshot Trace Logs:

Enabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_EnableWebDiagramView
PBI_improvedFilterExperience

Disabled Preview Features:
PBI_FuzzyMatching
PBI_qnaLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Able to change storage mode to imported and file saves and operates fine

[Anonymous]

The problem appears to be using directquery with min max on datetable of imported table

[v-qiuyu-msft]

Hi @Anonymous,

Would you please share detail steps for us to reproduce the issue? 

By the way, there is a Power BI desktop February version 2.66.5376.1681 released. You can try to test with this version to see if the same issue occurs. 

Best Regards,
Qiuyun Yu 

[Anonymous]

1. import a table (SQL this case) as Direct Query

2. create a date table with min and max for date range from a date field in the table imported in step 1. 

3. save the file

[v-qiuyu-msft]

Hi @Anonymous ,

I have tested on my side with Power BI desktop version 2.66.5376.1681 64-bit (February 2019) but not able to reproduce the issue follow your steps: 

I see you create a table use other functions besides Calendar() function. Please just create a table use Calendar() function to see if the same issue occurs. Also please try the same Power BI desktop version as ours then test again. 

Best Regards,
Qiuyun Yu