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 2020 release wave 2. There are currently three ways.

Source : Dynamics 365 Lab
Read more…

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. You may also know that there are some data sources where query folding does take place but where View Native Query remains greyed out.

Source : Chris Webb’s BI Blog
Read more…

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 services, but when confronted with a website where you have to click a button to download a file there’s a problem.

Source : Chris Webb’s BI Blog
Read more…

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 : Prisma informatik GmbH
Read more…

Set up Common Data Service connection for Business Central

Today we set up Common Data Service connection for our Business Central environment.

I really appreciate Renato Fajdiga for his blog about this topic but I think I could add more details to that. Also I’m planning additional articles about CDS integration and you’ll need initial setup to start with.

Source : Andrey Baludin
Read more…