Forum Discussion

jashjacob's avatar
jashjacob
Helper I
6 years ago

Filter data from Business Central source before retrieving

My company has a lot of reports with MS Business Central as a source. After a recent upgrade of Business Central, many of the reports are failing. The cause for this is some specific dataset in the Business Central database. This error stops the load from getting any data at all. One way I think I can resolve this is by filtering out before or while fetching the data from the server. In SQL, I could have used a select statement as source.

 

Is there a way to do this for a Business Central source?