open in Excel option not showing data

(1) Share

Report

Posted on by YasirShahzad

534

Hello Experts,

one of my user is facing an issue that when he opens the data according to the given picture, the excel file is showing no data even data is there.

[Obsolete] sales order header and lines... i know its obsolete but a few days before he is using this, and data was showing when he uses this option.

pls see the pic to know more detail about this and advise me how to resolve it.

I have the same question (0)

All responses (11)

Answers (1)

Waed Ayyad 9,061 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you try the other entities? For the other users if you used the same entity did return data?

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
YasirShahzad 534 on at

Like (0)

Report
Copy link

Link copied!

Dear Waed,

thanks for your response, i have tried other options and its working fine..

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,516 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you please try to delete the cache?

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can try another way to export the data. If users are unable to access the data through the open in Excel option, you can try other export options such as using data entities or reports to export the data and see if you can successfully obtain the data. Or you can also try restarting the server. This problem may be caused by the server's cache.

Best regards,

Kevin

Was this reply helpful? Yes No
YasirShahzad 534 on at

Like (0)

Report
Copy link

Link copied!

Kevin Xia

thanks for your response, actually user uploading data on regular basis through this, i know data can be obtain from data entities but here scenario is different, user uploading bulk data through this functionality and its not working now.

Was this reply helpful? Yes No
YasirShahzad 534 on at

Like (0)

Report
Copy link

Link copied!

BillurSamdancioglu

can you pls share the process of cache removing in D365

thanks in advance

Was this reply helpful? Yes No
André Arnaud de Cal... 303,139 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Yasir,

Do you mean to say the same data entity gave data a few days back and now not anymore? Have you checked if there is a change applied to the security permissions?

Was this reply helpful? Yes No
YasirShahzad 534 on at

Like (0)

Report
Copy link

Link copied!

Andre Arnaud de Cal...

Hello Andre,

there is no change in security permissions, other options are working fine, but only highlighted entity showing no data during extraction.

Regards

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 303,139 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Yasir,

I tried this same entity and is working for me in a 10.0.38 environment. When the Excel workbook is opened, can you check the filters in the Dynamics connector? Maybe it is having a wrong order reference?

Was this reply helpful? Yes No
YasirShahzad 534 on at

Like (0)

Report
Copy link

Link copied!

Hello Andre,

I have this version.. 10.0.39.. but excellent and always helpful your suggestions resolve the issue... filter were apply, i just removed and its working fine now..

Was this reply helpful? Yes No