Creating new instances of Business Central web servers using PowerShell

Although you can use the Business Central Setup to install the Business Central Web Server components and create a single web server instance in IIS for client connection, there may be scenarios when you want to set up multiple instances.

For example, you could set up a separate Business Central Web Server instance for the different companies of a business, for this scenario, you can use the Business Central Web Server PowerShell cmdlets.

Source : Roberto Stefanetti NAV & Business Central Blog
Read more…

Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what happens when a dataset is refreshed, for example so you can find out exactly how long a refresh took, understand which tables inside the dataset contribute most to refresh times or which calculated columns or calculated tables take the longest to create.

Source : Chris Webb’s BI Blog
Read more…

Improving Productivity With Tight Integration Between Outlook And Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central offers tight integrations with Microsoft Office tools, including Outlook. Watch this short but informative video to see how this integration can make you more productive utilizing artificial intelligence, giving you visibility into your Business Central ERP directly from one of the most-used productivity tools, Microsoft Outlook.

Source : ArcherPoint
Read more…