Dynamic excel error: "This Web query returned no data....."

Question

Hi,

We are facing with an issue, when trying to refresh dynamic Excel data (Dynamic export from D365): "This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar."
As I see it's a long time known issue, but still there is no pemanent solution for this: https://community.dynamics.com/365/f/dynamics-365-general-forum/302537/dynamic-export-to-excel-message-this-web-query-returned-no-data/874964

https://support.microsoft.com/en-gb/help/277596/error-message-when-you-update-a-data-query-on-your-excel-worksheet-thi

Some of our users have to go through the workaround steps every time, when they open a new dynamic Excel, but for some of them this issue appears really rarely (approx. once per month.)

I would like to ask what settings can make the difference, or what can be the permanent solution on the application or on the device level?

Thank you for the reply in advance,
Adam

Answer 1

@Adam Mereg

Please give a screenshot as below to tell the version of Excel you are using.
File>Account>Product Information>About Excel
Note: please cover your private information if there is.

How do you connect to the Dynamic data?
It would be better to give the detailed steps.

Besides, I found a third-party link which may be related to your issue. It may be helpful for you.
https://carldesouza.com/error-connecting-to-dynamics-365-from-excel-cannot-download-the-information-you-requested/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Thanks for your understanding.

Regards,
Erin

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Erin,

The Excel version is:

The issues is exactly as described under the following links:
https://carldesouza.com/error-connecting-to-dynamics-365-from-excel-cannot-download-the-information-you-requested/
https://community.dynamics.com/365/f/dynamics-365-general-forum/302537/dynamic-export-to-excel-message-this-web-query-returned-no-data/874964

Steps:
Dynamics 365 has a native functionality, export the data into dynamic excel sheet. In this case the file contains a hidden, non-editable query, which can run only if D365 licenced user tries to refresh the dynamic data. The issue is, that Excel seems forgetting time to time the login data of the user for this connection (even so the user is loggen in with the same credentals to excel itself)
The workaround from the above mentioned links do work, but what is interesting (and I haven't found explanation) why some users have to to the whole workaround step-by-step every time they open a dynamic excel for some user it happens really rarely. Probably it is realted to some cached login settings, but I could not find any helpful description to entirely solve theis issue.

Answer 3

@Adam Mereg

To provide a better user experience, I suggest you to post your issue on Excel UserVoice.
This is a forum that Microsoft specifically uses to collect user’s feedback.

If you have any updates, you could also share them in this thread.

Thanks for your understanding.

Regards,
Erin

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.