web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance forum

Query not valid

(0) ShareShare
ReportReport
Posted on by 570

Dear all,

I try to build simple query report in D365, but while selecting query in the dataset is showing error "Query NOT valid".

And I did all basic steps. But still same error 

BR

Tony

  • Adam123 Profile Picture
    534 on at

    Dear all,

    I try to build simple query report in D365, but while selecting query in the dataset is showing error "Query NOT valid".

    And I did all basic steps. But still same error.

    Please answer this!

  • Suggested answer
    Deepak Agarwal Profile Picture
    9,339 Super User 2026 Season 2 on at

    Would be nice if you can share some more details with screenshot. Plz refer below link for more on x++ query.

    www.theaxapta.com/search

  • Suggested answer
    AmbalviUsman Profile Picture
    5 on at

    Make sure Synchronization with database is true and Build the model. Then you can select the query.

  • Shabir Ahmad Profile Picture
    3,124 on at

    QueryError.png

    Hi all ,

    This is the error which i am facing as well. Help and support. it is query based report and only 1 table cust table as data source.

    Best Regards,

    Shabir Ahmad

  • Shabir Ahmad Profile Picture
    3,124 on at

    3060.QueryError.png

  • Sanjay Joy Profile Picture
    5 on at

    You need to build the query first and then try to select this query in the dataset.

  • Ayodeji Osanyin Profile Picture
    30 on at

    Once you build the model, you will be able to add the query to the report. This works on visual studio 2019

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 Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans