Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

PBI Desktop crashing trying to load from Excel (local) - any file

I'm simply trying to connect to a local (this PC) Excel file, and every time I select the file then try to load it, PBI crashes.

Initially I thought it was because Windows 10 by default saves files to OneDrive, so instead I saved the file to 

C:\Users\rod_w\Desktop,

then tried to point Power BI there as the source and yet it's still crashing every time. 

 

I then thought it might be an issue with that particular file, so instead I selected another file, and the same thing is happening.

 

Here's an example of the crash in action: https://1drv.ms/u/s!AgytcDfT4DRFkIFfq2UVDov_Ve_C6Q?e=Oxnnd7

 

Here's the Power BI About info for this machine:

 

Feedback Type:
Frown (Error)

Timestamp:
2021-04-11T06:57:48.3254656Z

Local Time:
2021-04-11T09:57:48.3254656+03:00

Session ID:
5180eda1-17de-4c50-948e-43e34f872b13

Release:
March 2021

Product Version:
2.91.884.0 (21.03) (x64)

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

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

Peak Virtual Memory:
38.1 GB

Private Memory:
454 MB

Peak Working Set:
688 MB

IE Version:
11.789.19041.0

User ID:
5b9721d6-c59a-4e41-8be5-88f761d0ee6d

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\rod_w\Microsoft\Power BI Desktop Store App\FrownSnapShot35998882-4663-4ea3-9e00-a234ca4aab37.zip

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Performance Trace Logs:
C:\Users\rod_w\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_eimInformationProtectionForDesktop

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

Formulas:


section Section1;

Status: New
Comments
v-chuncz-msft
Community Support

@RodWhiteley 

 

I cannot reproduce the issue. You may try to download version from here and reopen the file.