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.
Hello All, Kindly help,
I have loaded excle file and it is giving "DataFormat.Error: File contains corrupted data." and not giving me the option to edit.
Any suggestions.
Solved! Go to Solution.
You cannot access password protected files, so that will need to be removed unfortunately.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou cann't access C3 files, so you'll will need to change that
Hi! @Anonymous
Can you check that your excel file has correct data type for all columns and there are no special characters in your data. The error seems to be due to the source file.
The problem is the excel files are password protected, after posting this help request. i noticed the files are loaded to share point with password protected.
You cannot access password protected files, so that will need to be removed unfortunately.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi, we are having the same issue after a system update on the program that generates the reports. They aren't password protected, is there something else we can try?
Hi, I think we might be having the same issue. Do you use Wdesk, and were you able to find a solution?
We've had to open each new report in Excel and enable editing. Checking with our IT to see if that can be turned off
Did you find an answer to this question?
If your query is collecting Excel files from a folder, it might be that a hidden file is located in the folder. These files have file names preceded by a dollar sign ($). View hidden items in the source folder and delete any files beginning with a dollar sign ($). This has happened to me several times.
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.