377

Report Inspector

Similar to the page inspector, we would like to have a report inspector. The report inspector should allow us to see: - The ID and Name of the current report - The current selected layout (ID, Name, Type) of the report - The Dataset, it's values, and applied filters, of the current report - Any ...

Read more...

22 Comments

Read more... 22 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We have built a feature in 2021 Wave 2 that supports saving report dataset to Excel, either for use by developers, consultants or power users as part of developing report layouts (i.e., similar to About this Report known from the Windows client, but in Excel instead), or for use by end customers to export report data to Excel for further processing, e.g., filtering or pivoting. This feature can be tried out in the insider build  artifacts already for vnext/v19 (use "Save as Microsoft Excel (data only)" option in report request page), but as we plan and hope to also backport this to a 2021 Wave 1 minor (currently targeting v18.3) due to demand and usefulness, this idea is marked for April 2021 release for now.

Update July 6th 2021: 
We have shipped this in Minor Update 18.3. See Docs for more: Working with Reports, Batch Jobs, and XMLports - Business Central | Microsoft Docs

Peter Borring
Program Manager, Microsoft 
211

Direct printing

One of the biggest lack on D365BC SaaS is the direct printing functionality. On scenarios like warehouse and production having the possibility to direct print a report to a local printer is a must to have. Why not creating a functionality for that? It could be possible to handle this scenario wit...

Read more...

14 Comments

Read more... 14 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Good news! We released this feature as part of the functionality in Enable non-interactive printing in the cloud.
Please refer to the following link for more information:
 
Best regards,
Blazej Kotelko
Program Manager, Microsoft

120

Add Business Central as a Data Source in DataFlows

Currently it is not possible to connect a DataFlow directly to Business Central, like it is in Power BI Desktop: https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-define-new-entities https://docs.microsoft.com/en-us/power-bi/connect-dat...

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for this suggestion! We were working with Power BI team to enable this (not related to the Business Central version):

Microsoft
85

Allow users to add filter fields on report option

When running a report, a user can choose a filter for the pre-defined fields or replace an existing filter field with a new one, but a user can't add additional filter fields. For example, the Inventory Valuation report offers three field to filter on. Let's say the user makes use of these thr...

Read more...

6 Comments

Read more... 6 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We released this feature as part of the functionality in Business Central 2019 release wave 2. Please refer to the following link for more information: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/powerful-filtering-capabilities-reports Your help was greatly appreciated, Mike Borg Cardona Program Manager, Microsoft
82

Publish more data for PowerBi, specifically for Dimensions report

We would like to be able to do reporting in PowerBi on Dimensions.  Currently, the dimension set ID field from table 20 is not published on page 20 that we can publish to PowerBi.   

This would make reporting much easier with Excel and PowerBi.

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Completed in a previous release

Best regards, Business Central Team
42

Shared Workspaces in Power BI embedded in Business Central to be supported

The Power BI embed the experience in Business Central was built before Power BI introduced the concept of Shared Workspaces. Does Microsoft plan to implement the Shared Workspaces work properly in Business Central?

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for this suggestion! 
We are delivering this feature with the 2021 release wave 2 of Business Central (October 2021).

Best regards, 
Blazej Kotelko
Business Central Team
39

Easily apply / type new filters on report request page

One cool thing about the upcoming PAGE filtering feature is that we will be able again to 'type' (search) a field name we would like to filter on, instead of selecting by mouse. Can we imagine similar behavior for the REPORT request page filtering as well? Being able to just type to search for...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We released this feature as part of the functionality in Business Central 2019 release wave 2. Please refer to the following link for more information: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/powerful-filtering-capabilities-reports https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/filtering-option-fields-multiple-values ​ Your help was greatly appreciated, ​ Mike Borg Cardona PM, Microsoft
31

Extend the Power BI Business Central connector to connect to a sandbox instance.

Please extend the Power BI Business Central connector to also let us connect to a sandbox instance? That way, when developing reports, you can use sandbox data and when the report is finished you can change the connection to a live environment. Using the ODATA connector it's simple, using the B...

Read more...

7 Comments

Read more... 7 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
This functionality was added with the 2019 Wave 2 release. 

Thank you.
Brian Meier
PM, Microsoft
26

Be able to copy/export Account Schedules

We often run the same financial report in slightly different versions, such as an detailed income statement and a summary income statement.  It would save a lot of time if we could simply copy an Account Schedule and edit it, rather than building an account s...

Read more...

9 Comments

Read more... 9 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator

Thank you for your feedback. We released this feature as part of Business Central Fall 18 (October) release.
Please refer to the following link for more information:
https://docs.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule#to-copy-an-existing-account-schedule
 
Sincerely,
Ivan Koletic
PM, Microsoft

17

Hold active filter in Power BI Report when selecting "Expand Report" in Power BI factbox

If you have an Power BI report on a list, for example the item list and the Power BI filter on all pages is set to item no. in the factbox of the itemlist it shows the Power BI report filtered on item no. When selecting on the Power BI report > Expand Report, the system opens the Power BI report ...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (302)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for this suggestion! 
This is already fixed in production in the newest version of the product.
Best regards, 
Business Central Team