Not able to load data into Power BI

[TCYLo]

Hello,

I am trying to load data into Power BI.  It shows error message "Requested value '()1' was not found" and the data cannot be loaded, no matter I was using GET DATA function of ENTER DATA function.  Please advise how to solve it.

Below are the details copied from the system.

**************************************************************************************

Feedback Type:
Frown (Error)

Timestamp:
2019-12-05T01:49:12.1812638Z

Local Time:
2019-12-05T09:49:12.1812638+08:00

Session ID:
4205f7b8-4f39-423e-8d90-cf51c41b9ed6

Release:
October 2019

Product Version:
2.74.5619.621 (19.10) (x64)

Stack Trace:
at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at Microsoft.AnalysisServices.Tabular.RowsetPropertyReader.Microsoft.AnalysisServices.Tabular.IPropertyReader.TryReadProperty[T](String propName, T& propValue)
at Microsoft.AnalysisServices.Tabular.Partition.ReadAllBodyProperties(IPropertyReader reader, Int32 dbCompatibilityLevel)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactRow(ObjectType objectType, Int32 dbCompatibilityLevel, RowsetPropertyReader rowsetPropReader, ServerImpact serverImpact, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactTable(ObjectType objectType, Int32 dbCompatibilityLevel, DataTable tbl, ServerImpact impact, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadImpactFromSchema(DataSet schema, Int32 dbCompatibilityLevel, ServerImpact serverImpact, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.ImpactDataSet.ConvertToServerImpact(Int32 dbCompatibilityLevel, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.ExecuteUtil.TryExecuteXmla(String xmlaRequest, Database db, Model model, TxManager txManager, XmlaResultCollection& xmlaResults)
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.PowerBI.Modeler.ModelManager.SaveChanges(String description)
at Microsoft.PowerBI.Modeler.DateTableSubsystem.CreateDateTableTemplate(DateTableDefinition definition)
at Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables()
at Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableAutomaticLocalDateTables()
at Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableTimeIntelligenceIfNewModel()
at Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables()
at Microsoft.PowerBI.Modeler.ModelManager.PopulateTableItems(Table table, ModeType modeType, List`1 columns)
at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Visit(NewTableSchemaChange schemaChange)
at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass13_1.<ExecuteChange>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange, Boolean saveChange)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.ApplyQuerySchemaToModel(IModelInput modelInput, IExtendedModelChangeScope modelChangeScope, Boolean requireFullDataRefresh)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.ApplyQueriesToModel(IAnalysisServicesLoadContext loadContext, IExtendedModelChangeScope modelChangeScope, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean& runRelationshipDetection, List`1& newTableColumnPairs, HashSet`1& previouslyLoadedInputs)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.ProcessLoadInputs(IPowerBIWindowService windowService, IExtendedModelChangeScope modelChangeScope, Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass16_0.<PerformLoadInternal>b__0(IExtendedModelChangeScope modelChangeScope)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.<>c__DisplayClass16_0.<RunExtendedModelChangeAsync>b__0()
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Utilities.TaskExtensions.WaitAndUnpackException(Task task)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.PerformLoadInternal(IPowerBIWindowService windowService, Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean skipImpactAnalysisWarning)
at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass15_0.<PerformLoadAsync>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- 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.Modeling.LoadToReportFlow.<PerformLoadToAnalysisServices>d__29.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.Modeling.LoadToReportFlow.<Execute>d__21.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.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass29_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass29_0.<<StartLoadToReportFlow>b__0>d.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.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

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

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

Peak Virtual Memory:
34.1 GB

Private Memory:
329 MB

Peak Working Set:
500 MB

IE Version:
11.1504.16299.0

User ID:
3071a23d-58e8-4d7d-ba62-21a490a533bd

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

Telemetry Enabled:
True

Model Default Mode:
Empty

Snapshot Trace Logs:
C:\Users\TCYLo\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1456141042.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_realTimeRefresh
PBI_userFavoriteResourcePackagesEnabled
PBI_tenantOutOfBoxVisualsEnabled
PBI_personalVisualizationPaneEnabled
PBI_QueryDiagnostics

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[neilpalmer]

Hi. I have had the same issue. Microsoft have been assisting with trace after trace - now more than 2 months later, and over 6 streaming sessions with them, i have the same issue. Today I did a laptop Reset and installed Power BI fresh - same issue. In my findings it is laptop related, the same report run in the service works fine, or if I perform the same steps from another machine, it works perfectly. Any assistance on a fix would be greatly appreciated. 

[giedi]

Hi to all, after the last update of PBI Desktop I got the same error: Requested value '()1' was not found. How is it possible to solve it? I will be grateful for your help! 

[v-jayw-msft]

Hi @TCYLo ,

Could you please describe it in detail about what kind of data source you were loading and how did you load the data source?

In addition, please try uninstalling and removing the root then reinstalling the latest application.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TCYLo]

Hi Jay,

I had same problem in the version I installed before.  I thought that version got problem and had uninstalled and installed another version already.  However, same error message prompted.

I only typed a simple worksheet with 3 columns and few rows as testing, and using GET DATA function to load the data.  After the message 'There are pending changes in your queries that haven't been applied.' prompted for few seconds, the error message prompted.  I have tried to change the file to CSV type and using GET DATA to load the data, it didn't work.  And have tried typing the data by using ENTER DATA function, it didn't work.

I am using Windows 10 Enterprise and Microsoft Office 365 ProPlus in my notebook.

Please help to check.

Best regards,

Tweety

[v-jayw-msft]

Hi @TCYLo ,

It sounds quiet strange. I would like to suggest you to create a support ticket for further analysis.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TCYLo]

Hi Jay,

I've checked the log message.  It states that the file namely 'FlightRecorderSnapshotDef.xml' not found.  I checked the folder, it really not exist.  The folder only has another file with similar name as 'FlightRecorderTraceDef.xml'.  Could you send the missing file to me?

Best regards,

Tweety

[v-jayw-msft]

Hi @TCYLo ,

Does the file work? Please mark this topic as solved if it worked.

Please tell me if you need any further help.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TCYLo]

Hi Jay,

The error message still prompted although the log message related to that file not exist.

From the message log, there are other messages.  One of them is "The message manager for the 3081 locale cannot be found.".  It seems not appropriate to copy all those details here.  Not sure whether it is fine to email those details to you for checking.

I have asked IT department to check the SSAS and not yet got the reply.

Thanks & regards,

Tweety

[v-jayw-msft]

Hi @TCYLo ,

Looks like there's something wrong with your SSAS. I strongly recommend you to contact your IT department. 

Here's the file, hopefully works for you. Please make a backup before any operations.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.