Do you want to learn how to create Power BI reports consuming the standard out-of-the-box API’s in Business Central? Ever wanted to know what you can use the BC API’s for in Power BI without the need for any AL development? Then have a look here: Create Stunning Power BI Reports Using the Standard BC … Read More →
A question I recently received is: I created a Power BI report with Business Central data from my Business Central tenant and now I want to publish the report to the tenant of the customer, how does that work? Let’s start with an example report. In this report I will connect to the Customers … Read More →
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 →