Forum Discussion
Combine excel file error on table
Hi i having issue on query.
I have a lot of csv file on share point, and i combine this but when i refresh sometimes it goes well but sometimes error in table on few file do you know why ?
My csv file don't have any issue,
12 Replies
- IceyCommunity Support
- tranthanhtaiRegular Visitor
- IceyCommunity Support
Hi tranthanhtai ,
Just click on it to combine files.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
- PhilipTreacySuper User
Hi tranthanhtai
I don't see any error?
The icon you circled in red will combine those (binary) file contents if you click on it.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up. - mussaendaCommunity Champion
Hi tranthanhtai ,
it is not an error.
That is the content of your csv file.
Try combining them using the icon so you can see the contents of your files
- tranthanhtaiRegular Visitor
Hi i combine the file and as you can see on the right column there is some error but no error message.
I take my file from a sharepoint
- IceyCommunity Support
Hi tranthanhtai ,
Click on the cell with "Error" and the error message will appear.
Best regards
Icey
- tranthanhtaiRegular Visitor
I click on error and it just simply open the file
Thank you
- PhilipTreacySuper User
Hi tranthanhtai
Tha doesn't make sense. If it's an Error then it wouldn't open the file when you click it. It would show the Error message.
If you click into the cell beside the word Error (shown here in green)
Then at the bottom of your screen you should see the error message.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.- tranthanhtaiRegular Visitor
Hi im sorry i missunderstood
DataSource.Error : SharePoint: Échec de la requête : https://***.sharepoint.com/sites/***/Documents partages/0 - ORIGINE/2020/E@sy_Board_ 0'_v15-9-3-2020_csv/_api/contextinfo
Détails :
DataSourceKind=SharePoint
DataSourcePath=https://***.sharepoint.com/sites/***
SPRequestGuid=9591959f-b07f-b000-ad39-04d0a10a773e
Hi here is the message error ( i just remove the company name)
I use sharepoint so i don't understand why i can't get file randomly
- PhilipTreacySuper User
Hi tranthanhtai
no problem 🙂
If you try to access that file directly can you? Does that file actually exist?
Phil
- tranthanhtaiRegular Visitor
Yes i can there is no probleme with the file i can open it modify it...
The probleme is sometime it get error and sometime there is no error