0 Kudos

Direct Query and Custom Date Table

Status: New
by JScottatHornady Visitor on ‎02-08-2019 02:25 PM

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.

 

2019-02-08_16-04-34.png2019-02-08_16-18-09.png

 

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

Comments
by JScottatHornady Visitor
on ‎02-08-2019 02:30 PM

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

by JScottatHornady Visitor
on ‎02-08-2019 02:47 PM

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

 

2019-02-08_16-45-42.png

by Moderator v-qiuyu-msft
Tuesday

Hi @JScottatHornady,

 

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 

by JScottatHornady Visitor
yesterday

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

Idea Statuses