Error when importing excel data model into Power BI

[Anonymous]

Trying to import data model from excel and I get error:

Feedback Type:
Frown (Error)

Timestamp:
2020-12-01T14:21:57.3743137Z

Local Time:
2020-12-01T08:21:57.3743137-06:00

Session ID:
08189baf-88cb-4188-a9b8-aa278f00f1fe

Release:
October 2020

Product Version:
2.86.727.0 (20.10) (x86)

Stack Trace:
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<>c__DisplayClass17_0.<SyncQueryAndTableNames>b__0(ITable t)
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.SyncQueryAndTableNames(Report newReport)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.UpdateConnectionStrings(IAnalysisServicesService analysisServices, String globalPipeName, ImportFromExcelSummary resultSummary, String newDatabaseName, List`1 listNonMQueries, CancellationToken cancellationToken, IProgress`1 progressHandler, List`1 deletedQueries, Report newReport)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.TryCreateReport(CancellationToken cancellationToken, IProgress`1 progressHandler, Stream fileStream, Dictionary`2 linkedTableMapping, IImportFromExcelHost host, Dictionary`2 sharedStrings, Report& newReport, ImportFromExcelError& error, ImportFromExcelSummary& resultSummary, PackageValidationResult& validationResult, Boolean& tryImportEmbedded)
at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<>c__DisplayClass6_0.<CreateReportAsync>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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.ImportFromExcelDialog.<<StartImport>b__24_0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.86.727.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter+<>c__DisplayClass17_0","Error":"System.NullReferenceException","MethodDef":"<SyncQueryAndTableNames>b__0","ErrorOffset":"0"}

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

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

Peak Virtual Memory:
1.73 GB

Private Memory:
526 MB

Peak Working Set:
551 MB

IE Version:
11.1198.18362.0

User ID:
be84ceb9-d359-4d18-9aac-b642373dc9d5

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

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
True

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_v3ModelsPreview
PBI_dataSearchCuration
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox
PBI_dynamicParameters

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous · Accepted solution]

Hello @djonesokc,

As for Excel data mode, there are the following restrictions:

• External connections to SQL Server Analysis Services tabular models: In Excel 2013, you can create a connection to SQL Server Analysis Services tabular models and create Power View reports on these models without importing the data. This type of connection is not currently supported as part of importing Excel workbooks into Power BI Desktop. As a workaround, you must recreate these external connections in Power BI Desktop.
• Hierarchies: This type of data model object is not currently supported in Power BI Desktop. Therefore, hierarchies are ignored as part of importing an Excel workbook into Power BI Desktop.
• Binary data columns: This type of data model column is not currently supported in Power BI Desktop. Binary data columns are removed from the resulting table in Power BI Desktop.
• Unsupported Power View Items: There are some features in Power View that are not available in Power BI Desktop, such as themes or certain types of visualizations (scatter plot with playback axis, detailed behaviors, and so on). These unsupported visualizations result in unsupported display messages in their corresponding locations in the Power BI Desktop report, which you can delete or reconfigure as needed.
• Named ranges they use From Table in Power Query or With Excel.CurrentWorkbook in M: Importing this named range data into Power BI Desktop is not currently supported, but this is a planned update. Currently, these named ranges are uploaded to Power BI Desktop as a connection to the external Excel workbook.
• PowerPivot to SSRS: External PowerPivot connections to SQL Server Reporting Services (SSRS) are not currently supported because that data source is not currently available in Power BI Desktop.

Best regards

Liu Yang

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , Please upgrade to the Latest power bi version Nov 2020 and try. If this does work on Nov 2020 - then log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues