Generating Excel Reports Using Power BI, Cube Formulas, Office Scripts And Power Automate

Now that Excel reports connected to Power BI datasets work in Excel Online it opens up a lot of new possibilities for doing cool things with Office Scripts and Power Automate. Here’s a simple example showing how all these technologies can be put together to automatically generate batches of Excel reports from a template.

Source : Chris Webb’s BI Blog
Read more…

Dynamics 365 Business Central: Save report dataset to Excel from the request page (Report Inspector)

As you might know, in Business Central and NAV windows client, we can view and save the report dataset from the preview page, similar to the page inspector. For the development of complex reports, it is very important to be able to analyze the data before print. This would be very useful for creating and debugging RDLC reports.

Source : Dynamics 365 Lab
Read more…

Report Inspector 2.0 – How to export your report dataset as Excel, XML or Windows client style

Today’s post covers some programming that is not of my own making. My colleague Andreas Rascher has built a damn cool functionality that allows you to export the dataset of RDLC reports in different formats. Since we think the functionality is extremely useful, we didn’t want to keep it from you.

Source : Business Central Deep Dive
Read more…