srenders

08Apr 2020

Quick Tip: How do I import an license (flf) file in Business Central on Premises?

by srenders ⋅ 1 Comment

Since C/Side has gone forever, when installing Business Central on Premises you might wonder how to import or upload a license (flf) file into the service tier. Well the solution is very simple. First open the Business Central Administration Shell: Then use the command: Import-NAVServerLicense: More information is available here: https://docs.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management/import-navserverlicense?view=businesscentral-ps-16 After importing a new … Read More →

08Apr 2020

Quick Tip: How to fix the Business Central on Premises 2020 Wave 1 Installation Error?

by srenders ⋅ 2 Comments

Microsoft released Dynamics Business Central on Premises 2020 Wave 1 and you can download the On Prem installation DVD here: https://mbs.microsoft.com/partnersource/northamerica/support/support-news/msdbcentralonprem20wave1 But when you do an installation, you might get the following error: This happens if you don’t meet the system requirements: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/deployment/system-requirement-business-central-v16 To confirm, you don’t need the SQL enterprise edition, SQL Express is … Read More →

08Mar 2020

Using the power of Queries to bring some Smartness into Business Central

by srenders ⋅ Leave a Comment

Currently there’s a lot of talk about Business Central performance. Microsoft has released and is releasing guidelines, tools about mechanisms to program for performance, analyse and monitor performance. At the same moment there’s also discussions going on on public and private fora about database size and limitations. And last but not least Artificial Intelligence is … Read More →

26Feb 2020

Quick Tip: Interesting aka.ms links for Business Central

by srenders ⋅ 1 Comment

Here are some interesting aka.ms links I have found: aka.ms/bcideas Dynamics 365 Application Ideas for Dynamics 365 Business Central aka.ms/bccountries Country/Regional availability and Supported Translations aka.ms/collaborate Microsoft Collaborate aka.ms/readytogo The “Ready to Go” Program aka.ms/bclearn Microsoft Learn for Business Central aka.ms/bcproductivity Working with Business Central aka.ms/bckeys Keyboard Shortcuts aka.ms/bcupdates Major Updates of Business Central Online … Read More →

22Feb 2020

Quick Tip: Create your preview environments for Business Central 2020 release wave 1

by srenders ⋅ 1 Comment

Try out the new Business Central 2020 release wave 1 functionality today! Learn how to prepare for major updates with preview environments: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/preview-environments Are you interested to test out all the new bells and whistles of BC version 16, then create your preview sandbox as follows. Go to your Business Central Admin Center: Then spin … Read More →

19Feb 2020

Power BI Desktop February 2020 is out and Incremental refresh is now generally available!

by srenders ⋅ 9 Comments

Microsoft has announced the release of Power BI Desktop: February 2020 and you can read all about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/ I am very happy about incremental refresh, which is now generally available and is now supported for Power BI Pro licensing, meaning it is no longer a Premium only feature! Read all about that here: … Read More →

13Feb 2020

How Do I: Add a Drill-Through to See Records in Power BI Desktop?

by srenders ⋅ 1 Comment

Imagine you have created an amazing Power BI report that summarizes information using different visuals. Power BI Desktop lets you build advanced queries, models, and reports that visualize data and the idea is that the individual records that come from your data source are aggregated and summarized in your report, giving you the possibility to … Read More →

10Feb 2020

How Do I: Create a Report based upon a Query?

by srenders ⋅ 1 Comment

Performance wise it can be very interesting to use query objects as a data-source in a report (or any other object). Imagine you want to create a report that shows the top X records from a table, let’s say for example Customers, then creating a report dataset with a top-x filtering can be very cumbersome. … Read More →

02Feb 2020

How Do I: Implement an Incremental Refresh in Power BI (Free or Pro)?

by srenders ⋅ 5 Comments

A question I get a lot in my Power BI training for Business Central, and non Business Central companies is the following: How can I implement an incremental refresh, without building a data warehouse and without buying a Power BI Premium license? And to be honest, the answer is, it’s not really possible, but there’s … Read More →

23Dec 2019

How Do I: Power BI Pages versus Queries

by srenders ⋅ 2 Comments

I recently came across a question in the Business Central forum: How do I get information about Posted Sales Shipments in Power BI? And this is not a standalone question, I get these questions a lot in my training’s that I deliver all over the world. Many times I see answers suggesting to use existing … Read More →

14Dec 2019

How do I: Add filters in a Report in VSCode with AL?

by srenders ⋅ 1 Comment

Recently someone asked me, what’s wrong with me report, it’s not showing me the correct data? After investigating I noticed that the report used filters, applied in several different ways and that the expected data was not showing up in the dataset, and then of course it was also not displayed in the layout. So, … Read More →

14Dec 2019

Quick Tip: Where do I find the Released Cumulative Updates for Business Central?

by srenders ⋅ Leave a Comment

Released Cumulative Updates for Microsoft Dynamics 365 Business Central on-premises: https://support.microsoft.com/en-us/help/4470116/released-cumulative-updates-for-microsoft-dynamics-365-business Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2: https://support.microsoft.com/nl-be/help/4528706/released-updates-for-microsoft-dynamics-365-business-central-2019 Dynamics 365 Business Central On-Premises Spring 2019 Updates: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/deployment/update-versions-14

25Nov 2019

Quick Tip: Why is my Power BI report not available in the Business Central list?

by srenders ⋅ Leave a Comment

Imagine you have created a Power BI report and you want to display in in the Customer list. Then you need to add a report filter in the Power BI report, before you publish it to your work space: Then in Business Central you can go to the customer list page and in the Power … Read More →

23Nov 2019

How Do I: Create a Green-Bar report in RDLC?

by srenders ⋅ Leave a Comment

During my reporting workshops I sometimes get the question, is it possible to create a GreenBar report and how do you do that in a matrix? A GreenBar report is actually a report where you apply shading to every other row or column. So let’s start with a simple example and let’s create a simple … Read More →

16Nov 2019

Quick Tip: Check out the new #BCALhelp hashtag

by srenders ⋅ Leave a Comment

Tip of the day: Have you checked out the new #BCALhelp hashtag? Remember that you can use it to ask questions directly to the #MSDyn365BC community. There’s already a lot of informative discussions going on: