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

Accepted Solutions
Community Support
Community Support

Re: Power BI Feb 2020 - Error on Combine Files

@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
Community Support
Community Support

Re: Power BI Feb 2020 - Error on Combine Files

@susant ,

 

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

 

Regards,

Jimmy Tao

hpatricio
Regular Visitor

Re: Power BI Feb 2020 - Error on Combine Files

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

bushpalaneelima Advocate I
Advocate I

Re: Power BI Feb 2020 - Error on Combine Files

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

delphineedater
Frequent Visitor

Re: Power BI Feb 2020 - Error on Combine Files

we have the same problem on every post in my company

susant
New Member

Re: Power BI Feb 2020 - Error on Combine Files

(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?
Community Support
Community Support

Re: Power BI Feb 2020 - Error on Combine Files

@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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors