cancel
Showing results for 
Search instead for 
Did you mean: 

Direct Query and Custom Date Table

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

Status: New
Comments

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

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

 

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

Moderator

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 

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

Moderator

Hi @JScottatHornady ,

 

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