Data – Page 8 – Pardaan.com

Analyze data using Query Analyzer in Business Central

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…

24 November 2020

Dynamics NAV & BC Tips & tricks

Basics of JSON data types in Business Central

This post is about understanding the basics of JSON and how to handle JSON data in Business Central AL Language using JSON data types. JSON data types are introduced in AL Language with Business Central / Microsoft Dynamics NAV 2018. JSON stands for JavaScript Object Notation.…

3 November 2020

Dynamics NAV & BC Tips & tricks

Monitoring changes in Dynamics 365 Business Central 2020 release wave 2 (Change Logs, Field Monitoring and Data audit system fields)

A common challenge in many business management applications is avoiding unwanted changes in data. It could be anything from an incorrect customer name to an incorrect posting to the general ledger. In this blog we will summarize how to Monitor Changes in Dynamics 365 Business Central…

20 October 2020

Data & Analysis

View Native Query Now Works For Analysis Services Data Sources

If you’re familiar with the topic of query folding in Power Query, you’ll know that the View Native Query right-click option in the Applied Steps pane of the Power Query Editor can be used to show the native query that is run against the data source.…

13 October 2020

Data & Analysis

Exporting Data From Websites For Use In Power BI Using Power Automate UI Flows

As a Power BI developer I know how Power Query makes it easy to get data from web sources, but I also know there are limits to what it can do. I can get data from tables on web pages, I can get data from web…

7 October 2020

Dynamics NAV & BC Tips & tricks

Business Central: Disable data export to Excel for secure data processing

Dynamics 365 Business Central allows you to export data from Business Central to Excel for further processing. In some companies, this function is difficult to perform due to certain data processing and monitoring regulations. Administrators can now manage the control of data export to Excel. Source…

5 October 2020

Dynamics NAV & BC Tips & tricks

Business Central– From Docker container to SAAS

Why should I setup a Data Migration from my Business Central Docker Container to a Microsoft Dynamics 365 Business Central SaaS tenant: “Because I can?” Well, this might be one answer, but there are other good reasons. Let me explain. Source : NEVER STOP LEARNING Read…

9 September 2020