How do I: Create a mini report inspector?

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:

Source : Think about IT
Read more…

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…