Search and filter on a Flowfield
Please make it possible to search and filter on a flowfield. Currently when you open a list page and apply a filter on a flowfield, it does not work. There are a lot of Lookup flowfields, that fetch descriptions based upon No.'s and it would be really great if it was possible to filter and searc...
Entity-Relationship diagram (ER-diagram) for Base and System Application
An Entity-Relationship diagram (ER-diagram) about all tables, per functional area, for the Base Application and System Application would be extremely helpful. Anyone that wants to create reports (RDLC, WORD, PowerBI, other) at a certain moment needs to know where to find what information and ho...
Make Flowfields Searchable in Lists
Currently when you add a flowfield in a list page, it is not possible to search on that field. Please make this possible. In many cases Lookup flowfields are added to pages, allowing users to see master data descriptions/names in pages where only the No. is displayed. It would make sense, and cu...
Multiroot workspace: add launch settings in user-settings or workspace-configuration
In a multiroot workspace, in VSCode, there's a launch.json per project. In documentation it says that you can add the launch settings in the user-settings or the workspace-configuration, but AL still looks for a launch.json in the .vscode folder? Is it possible to get this working? https://code...
Using variable references in the launch.json file
Is it possible to uniform the content of the launch.json file using variable references? https://code.visualstudio.com/docs/editor/variables-reference Imagine you have multiple developers, each with their own docker container, for example: DEV-BC15-XX where XX is the name of the developer. It wo...
Query as Sourcetable/DataItem in Page/Report
It would be great to have the possibility to be able to use a query object as a SourceTable for a page and a DataItem for a report directly. Currently you have to program this. Having the possibility to be able to simply select the query object in the Sourcetable/DataItem would be a great impro...
Enable incremental refresh for Business Central in Power BI
Currently the Business Central connectors in Power BI, and Power Query, do not support incremental refresh: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#configure-incrementa...
Create an API for Automatic Deployment of Power BI reports to a BC tenant
Like extensions (.apps) it should be possible to automate the deployment of Power BI reports to a Business Central tenant. For example: in Power BI there are the Deployment Pipelines: https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-overview An alternative would be ...
Enable the modification of the PrintOnlyIfDetail property in Report Extensions
Make it possible to modify the PrintOnlyIfDetail property in a report extension. In a report extension, when you try to modify the PrintOnlyIfDetail, you get an error: The property 'PrintOnlyIfDetail' cannot be customized.AL(AL0246) When you add a data item, not being able to modify the PrintOn...
Implement a SQLJoinType property in Report objects
Currently the only way to implement an inner join or a left outer join between data items is using the PrintOnlyIfDetail property. In Query objects there's a SQLJoinType property. Why not also implement the SQLJoinType in reports, instead of the PrintOnlyIfDetail property? Better control over ...