Combine excel file error on table

[tranthanhtai]

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, 

[PhilipTreacy]

Hi @tranthanhtai 

no problem 🙂

If you try to access that file directly can you?  Does that file actually exist?

Phil

[tranthanhtai]

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

[PhilipTreacy]

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.

[tranthanhtai]

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

[tranthanhtai]

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

 

[Icey]

Hi @tranthanhtai ,

Click on the cell with "Error" and the error message will appear.

Best regards

Icey

[tranthanhtai]

I click on error and it just simply open the file

Thank you

[mussaenda]

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

[PhilipTreacy]

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.

[Icey]

Hi @tranthanhtai ,

What's the error message?

Best regards

Icey

[tranthanhtai]

 Hi sorry for late respond @Icey  there is no error message just error in the table

 

[Icey]

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.