Anyone would appreciate having important, much-used reports easily accessible from the appropriate places. A very helpful feature of Microsoft Dynamics 365 Business Central is the ability to add Power BI reports directly to your list views of customers, vendors, items, and more. However, there is a trick to making this work. Watch this brief video to learn how.
Now recently I came across a post from Bert De Temmerman on Yammer: https://www.yammer.com/dynamicsnavdev/threads/736254082498560 and that got my inspiration flowing…
He suggests that when you add this action to the “Report Layout Selection” page, you can export any dataset by first running the request-page:
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.
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.
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.