Hello! I'm new to D365FO. We are in the early stages of Implementation and I am using a LCS provided development environment running Version 8.
I am a BI Architect exploring various options we have in D365FO for reporting. One option (from several) was to look at SSRS reports. While exploring a Query Based report, I have encountered a problem after I create a Query from a single table. In this example, I am using VendTable.
Next, I create the report item - VendTableReport - and attempt to drag the query from above to the report Datasets element.
Upon doing so, I get the following message.
I am able to view data in the VendTable from the AOT using the Open Table Browser option. I know I can access the table and it has data. I have attempted this on several tables and have yet to be successful but one time against the CustTable table where I was able to complete the listing of that table with a Query Based SSRS report as of last week. This week I am striking out.
Has anyone seen this kind of behavior and can recommend a solution?
Thanks!
Shawn