Want to get started with Excel layouts for Business Central? Then have a look here: http://aka.ms/bcexcelsamples Business Central 2022 release wave 1 (version 20) introduced the feature Excel layouts as a way to layout and run reports using Excel. This repo contains instructions for how you can use different Excel and Power Query features in … Read More →
If you are using Business Central Telemetry in Azure Application Insights, then you might be very interested in this amazing Power BI report: BCTech/README.md at master · microsoft/BCTech (github.com) Use this link to install/update the template app: https://aka.ms/bctelemetryreport The report comes with sample data. To connect the report to an Azure Application Insights resource, you need … Read More →
Many times when you create a company in Business Central for a BE (Belgium) tenant, you will get your Cronus demo data in French when you actually wanted it in Dutch. If you have a Belgian trial version of Business Central and you are using the ENGLISH language in Business Central, THEN the setup … Read More →
In Power BI Desktop, and in the Power BI Service, Maps and Filled Map visuals might show up as follows: Don’t worry, there’s nothing wrong with your report, it’s a new setting, announced in October last year. Back in October, we announced that we were introducing a tenant-level setting to enable or disable Bing Maps … Read More →
In almost every PowerBI report at some point you will require time intelligence. You might want to display information on a timeline or create time based measures using DAX time intelligence functions. For that to work properly it’s a best practice to always create your own Date (or Calendar) table in the Power BI … Read More →
Did you know that Windows 10 came with a free remote control tool called Quick Assist? Quick Assist is an app in Windows 10 that enables you to receive or provide assistance over a remote connection. Here’s a video about it: https://www.microsoft.com/en-us/videoplayer/embed/RE4FyMn?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Give assistance Select Start > Quick Assist (or select the Start button, type Quick Assist in the search box, … Read More →
Yesterday Kennie Nybo Pontoppidan (@KennieNP) / Twitter announced on twitter that the new PowerPoint deck “Using telemetry to improve your partner practices and processes” is now available. You can find it here: BCTech/samples/AppInsights/Presentations at master · microsoft/BCTech (github.com) You can use it to evangelize the use of telemetry apart from troubleshooting, or to … Read More →
Recently the Power BI connector in Power BI Desktop allows you to harvest the power of Business Central APIs: In the Standard APIs folder you can see all APIs Business Central publishes automatically: API(V2.0) for Dynamics 365 Business Central – Business Central | Microsoft Docs And in the Advanced APIs you can find the … Read More →
Introducing the new landing page for all things related to reporting and data analysis in Business Central: http://aka.ms/bcreporting Similar to landing pages for security (http://aka.ms/bcsecurity), telemetry (http://aka.ms/bctelemetry), and performance (http://aka.ms/bcperformance), the new landing page should answer all questions that prospective or existing customers (or you) have about #msdyn365bc reporting. Please visit http://aka.ms/bcreporting and let … Read More →
Recently Microsoft added the Table Information page to Business Central. See here. And underlying are these objects: Table Information (8700, List) Table Information (2000000028) So I was thinking, hey let’s use this in Power BI. Then my first thought was to create a query object using the Table Information table as a data item, but … Read More →
Recently I stumbled upon Manage Sessions in the Business Central Admin Center: In the Admin Center, open an environment: Then select: Manage sessions: Now you can see and cancel sessions: More information is available here: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/tenant-admin-center-environments#managing-sessions The Manage Sessions page displays information about active sessions on an environment and lets you cancel selected sessions. To open … Read More →
I recently discovered this cool feature in Business Central: https://docs.microsoft.com/en-US/dynamics365/business-central/admin-feature-management When Microsoft releases features or feature design improvements as part of minor updates, some features aren’t immediately enabled. Administrators can learn about these features and independently enable each feature from the Feature Management page. Once a feature is enabled, it becomes available for all users on that … Read More →
I recently discovered this cool feature in Business Central: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-view-table-information The page 8700 Table Information provides information about all system and business tables in a Business Central solution. In particular, the page displays information about the amount of data the tables contain. This information is useful for troubleshooting performance problems, because let’s you see the distribution of … Read More →
I recently discovered this cool feature in Business Central: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-view-database-locks https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/monitor-database-locks The Database Locks page gives snapshot of all current database locks. To view database locks, open page 9511 Database Locks in the client. The Database Locks page gives a snapshot of all current database locks in SQL Server. It provides information like the table and database resource affected by the … Read More →