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.
Dataset properties in VS 2019 showing tied to Data source above.
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.
Browser (Sandbox) - These are the business units that I would expect to see when I preview the report in VS 2019.
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?
