Forum Discussion
Error when importing excel data model into Power BI
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
- Anonymous5 years ago
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.
2 Replies
- amitchandakSuper User
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
- AnonymousNot applicable
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.