cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
susant
New Member

Power BI Feb 2020 - Error on Combine Files

Feedback Type:
Frown (Error)

Timestamp:
2020-02-19T23:56:55.9095748Z

Local Time:
2020-02-20T12:56:55.9095748+13:00

Session ID:
452333bf-e2d9-4e61-ae44-aef5fda774e1

Release:
February 2020

Product Version:
2.78.5740.721 (20.02) (x64)

Stack Trace:
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)
at Microsoft.Mashup.Client.UI.Windows.JsHostedScript.TryInvoke[T](String script, T& result)
at Microsoft.Mashup.Client.UI.Windows.JsHostedScript.TryInvoke(String script)
at Microsoft.Mashup.Client.UI.Shared.EditorDialogBase.Reinitialize(String queryName, String stepName, JsonColumnSelectionInfo columnSelectionInfo)
at Microsoft.PowerBI.Client.Windows.PowerBIEditorCombineBinariesDataImporter.<>c__DisplayClass2_0.<.ctor>b__0(IEnumerable`1 addedQueries)
at Microsoft.Mashup.Client.UI.Shared.CombineBinariesDataImporterBehavior.OnAfterImportSuccess(IEnumerable`1 addedQueries)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

InnerException.Stack Trace:
Error: The active item should be a query
at refreshParts (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:156:13)
at Editor$_dispatchChange (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:43:13)
at selectFormula (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:152:13)
at Editor$_dispatchChange (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:43:13)
at reinitialize (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:84:13)
at Editor$_dispatchChange (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:43:13)
at cancelEvaluations (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:70:13)
at Editor$_dispatchChange (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:43:13)
at changeStart (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:66:13)
at Editor$_dispatchChange (ms-pbi://pbi.microsoft.com/ts/Editor/EditorState.js:43:13)

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

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

Peak Virtual Memory:
34.6 GB

Private Memory:
601 MB

Peak Working Set:
749 MB

IE Version:
11.1685.16299.0

User ID:
86e416ff-50e1-4ade-abed-f8274a0fdf01

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\susant\Microsoft\Power BI Desktop Store App\FrownSnapShot782705752.zip

Model Default Mode:
Import

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PBI_QueryDiagnostics
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree
PBI_themeDialog

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_hierarchicalSlicerCreation

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
200%

Supported Services:
Power BI

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@susant ,

 

I can reproduce this issue. The workarond is to combine the files directly when you load the data as below:

Capture.PNG  

 

Regards,

Jimmy Tao

 

 

View solution in original post

6 REPLIES 6
v-yuta-msft
Community Support
Community Support

@susant ,

 

I can reproduce this issue. The workarond is to combine the files directly when you load the data as below:

Capture.PNG  

 

Regards,

Jimmy Tao

 

 

View solution in original post

susant
New Member

(Jimmy Tao) there are only two files with two rows so it is not a size issue. The thought is that is something not quite right with the Feburary 2020 build?
delphineedater
Frequent Visitor

we have the same problem on every post in my company

bushpalaneelima
Advocate III
Advocate III

Hi Team,, even i am facing this issue of not working. 

hpatricio
Regular Visitor

I have the same error, in .txt and .xlsx files as source.

v-yuta-msft
Community Support
Community Support

@susant ,

 

This feature works well on my side. How large are the files? Have you tried different smaller files?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors