Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Query Editor loads fine no errors. Load fails after 20 minutes with this error
OLE DB or ODBC:[DataFormat.Error] cell value #REF invalid
I am appending 90+ excel files with 1800 Columns and unable to find which file or column is causing this.
how else can I isolate the root file or column?
thanks
use the try ... otherwise ... pattern
use the [Column]? pattern
Cut your file list into halfs, quarters, etc to faster identify the offending file.
Sounds like you may want to unpivot your files before combining? 1800 columns is way too much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |