Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Can anyone tell me why I keep getting this Obscure message- its the same data that worked 2 days ago without issue. I combed through the data- once again this is Excel data mainly dates- Ive been careful to stick to a generic Excel spreadsheet mode.
Open Power Query Editor → look for steps with errors (yellow triangle).
Check applied steps like Changed Type or Promoted Headers → update them to match the current data.
Ensure your Excel data is in a proper Table with consistent headers.
👉 Essentially, the query is expecting a column that no longer exists or has a null header.
I believe Ive found the cause of the error issue
It appears Excel blank cells in a column with numbers typed "General" for the column produce these errors
"Unable to get property type of undefined or null references"
At least thats what I got from Access's imported error table - once I Data-Typed the data in the column as "Number" the table uploaded into BI quietly. with over 10,858 rows in this table (..and this is test data) it was easily over looked
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 44 | |
| 43 | |
| 38 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 67 | |
| 63 | |
| 30 | |
| 30 | |
| 23 |