- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
error when reading file from Sharepoint
I uploaded .xlsx file into Sharepoint (or One Drive - I am not able to differentiate this), then accessed this data with Power BI Desktop - get data from Sharepoint folder. When trying to refresh I used to get this:
Now I am not able to do anything in query editor.
How to get through this?
Moreover, I noticed after uploading to sharepoint and downloading just after my file size droped from 450mb to 250mb.
When trying to open (excel already downloaded from Sharepoint) it is not working, saying sth like file is corrupted and about wrong extension.
Not sure what happens there
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Let me close this thread. Data are confidential so I couldnt share.
But the issue is somewhare in data. My remarks:
Excel on local drive is not read the same way as the same excel uploaded to sharepoint OR excel uploaded to sharepoint is converted causing Power BI cannot read data returning error. Of course it happens in specific cases which I cannot describe here because I couldnt find the row/s in data responsible for the error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous,
It seems that the Excel source file is corrupted as you are unable to open the downloaded Excel file. Please upload a valid Excel file to replace the existing Excel file in SharePoint, then connect to SharePoint folder in Power BI Desktop.
Regards,
Lydia
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Lydia
It is not exactly like this. The excel file is initially fine. Something happens after an upload. I tried saving it in binary format but with the same results. It looks like Sharepoint is changing sth in the file. Then when I download the file it becames corupted. Also Power BI desktop cannot read this file. Excel I mean is a simple database (about 750k rows and 30-40 columns)
There is no problems to connect to this file when it is saved locally on my computer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous,
Could you please share the Excel file so that I can test?
Regards,
Lydia
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Let me close this thread. Data are confidential so I couldnt share.
But the issue is somewhare in data. My remarks:
Excel on local drive is not read the same way as the same excel uploaded to sharepoint OR excel uploaded to sharepoint is converted causing Power BI cannot read data returning error. Of course it happens in specific cases which I cannot describe here because I couldnt find the row/s in data responsible for the error.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-20-2024 04:46 AM | |||
02-28-2024 10:47 AM | |||
Anonymous
| 09-30-2022 01:54 AM | ||
06-12-2024 08:16 PM | |||
02-09-2024 02:25 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |