Apr 2020 Quick Tip: How to create and embed a Power BI report into Dynamics 365 Business Central

In Microsoft Dynamics 365 Business Central, we have a more intuitive and faster way to create new Power BI reports that you can share with other users in Business Central. In this webinar, you will learn how to create and embed a Power BI report and learn about the options in Business Central to enable Power BI reports to end users.

Source : Think about IT
Read more…

Make Your Power BI Report Run Faster By Showing The Same Data In Fewer Visuals

Before we go any further, I don’t want you to go and change your reports if you’re not going to get any benefit from doing so. Use Performance Analyzer (as shown here) to determine which visuals on your report are the cause of slow performance – there’s no point redesigning visuals that are fast anyway.

Source : Chris Webb’s BI Blog
Read more…

How do I: Create a report based upon a query?

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.

Source : Think about IT
Read more…

Creating a Word Layout Report in Microsoft Dynamics 365 Business Central

In todays blog we will be discussing about Creating Word Layout in Business Central MSDYN365BC

If you want to Create RDLC Layout then ref to my previous blog

Creating an RDL Layout Report in Microsoft Dynamics 365 Business Central (MSDYN365BC)

So lets begin with Creating a AL File For the Word Layout

Source : Divyesh Chitte
Read more…

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

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.

Source : Think about IT
Read more…

How do I: Create a timeline in a report dataset in AL?

A question I got recently was, how can I visualize or create a dataset that can show/fetch information on a timeline? For example, I have a time-sheet and want to visualize the hours employees worked at certain projects, per day, week, month, year, and so on.

In this example I will create an order intake report. For the simple reason that for this report you can use the standard demo data in Business Central, and for time-sheets you first need to go threw a setup and then create the demo data.

Source : Think about IT
Read more…