Recently, I was asked how to change the output format of Duration data type, how to convert the unit to hours or minutes, etc. So, today I would like to briefly discuss Duration data type in Business Central.
This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so the old data was being loaded by mistake. The best solution here is to use some kind of external service (for example Power Automate) to poll the data source regularly to see if it’s ready, and then to refresh the dataset via the Power BI REST API when it is.
Inline Query Analyzer is a tool to analyze data in Business Central. This is an open source project intended to help developers for quick retrieval of data for analysis purposes. You can write SQL like queries to retrieve data. Users can view the query results in Grid and JSON views.