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,039 Super User 2025 Season 2 on at

Like (0)

Report

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

Dear Waed,

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

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Can you please try to delete the cache?

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

Like (0)

Report

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

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

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... 301,037 Super User 2025 Season 2 on at

Like (1)

Report

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

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... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

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

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