Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

FetchXML NOT Retrieving Data From Provided Datasource

Posted on by 20

I am baffled as to why I cannot get a very simple report to provide me with expected information when I run it in the sandbox vs when I preview it in VS 2019.

I downloaded a simple report from my sandbox environment. I mean it is simple - you'll see below.

Data Source In VS 2019 - showing our dev environment; copied/pasted the URI from Developer Resources module in the sandbox.

Report_5F00_Source.png

Dataset properties in VS 2019 showing tied to Data source above.

Report_5F00_DataSet_5F00_0.png

The query (told you it is simple):
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="businessunit">
<attribute name="businessunitid"/>
<attribute name="name"/>
</entity>
</fetch>

Results:

VS 2019 Preview - These business units are from my production environment. They're legitimate, but, they don't all exist in the data source to which I'm supposedly connected.

Results_5F00_Preview.png

Browser (Sandbox) - These are the business units that I would expect to see when I preview the report in VS 2019.

Results_5F00_Sandbox.png

There are 9 results in Sandbox and only 7 in the VS 2019 preview despite having the same data source - not even the id's match. I am expecting to see Manufacturing, Warehouse, Operations & Marketing when viewing in VS 2019.


Troubleshooting steps taken:
Deleted the local rdl.data file on multiple occasions
Whenever prompted to use cached credentials, I select No and re-enter them.
Disabled / Enabled Microsoft Reporting Services Tools
Installed / Repaired MS Report Authoring Extension

What else could I be missing?

  • Neil78 Profile Picture
    Neil78 20 on at
    RE: FetchXML NOT Retrieving Data From Provided Datasource

    Eureka!

    That was it. In all my troubleshooting, I did not check the box to list all available orgs.

    Thank you for your reply and suggestion.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FetchXML NOT Retrieving Data From Provided Datasource

    Hi Neil78,

    Do you have multiple Organizations?  If so, please make sure you select the correct one:

    pastedimage1662101993287v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,101 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,908 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans