How do you add a hyperlink (URL) to an RDLC report layout in Business Central? First, get your hands on the RDLC layout. If you are a developer, you can simply open the RDLC layout, because you have it in VSCode. If you are an end user, you need to open the layout in the … Read More →
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 →
When you try to deploy a PTE (per tenant extension) from VSCode (Visual Studio Code), and you get the following error: Your license does not grant you the following permissions on TableData Published Application: IndirectInsert or The request for path /v2.0/sandbox/dev/apps?SchemaUpdateMode=synchronize&DependencyPublishingOption=default failed with code UnprocessableEntity. Reason: Your licence does not grant you the following permissions … 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 →
A long time ago I described how you can add fields to reports in BC: How Do I: Add fields to a Report in Business Central? – think about IT but since then a lot has changed and the Report Extension object was introduced, which is a much better solution. What is a Report … 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 →
In this post I will demonstrate how you can create simple APIs of type Query and Page to be used in Power BI. The idea is to have a look at an example where we create 2 very simple APIs: a Customers Query and a Customers Page. In VSCode, create a new project using AL:Go! and … Read More →
DynamicsCon March 2022 is a FREE, 3 day virtual learning experience for 8,500+ Microsoft Business Application users and professionals. You will be immersed in programming covering Power Platform, Dynamics GP, and Dynamics 365 products: Business Central, Customer Engagement, Finance & Operations. Have a look at the agenda: Agenda – DynamicsCon And… I’m also speaking: … 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 →
A question I receive a lot recently is that after installing Visual Studio, the installation of the RDLC Report Designer produces an error: The install of Microsoft RDLC Report Designer was not successful for all the selected products. This extension is not installable on any currently installed products. The reason for this error is … 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 →