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 (300)

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 
327

Enable incremental refresh for Business Central in Power BI

Currently the Business Central connectors in Power BI, and Power Query, do not support incremental refresh: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#configure-incrementa...

Read more...

21 Comments

Read more... 21 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team
219

Option to merge multiple pdf files into one document

Our users want to batch print Sales Invoices. In WinClient we could solve that, but now when running WebClient only (SaaS) we're having different troubles. Since we need to use the configured Custom Report Layouts, we have to print the invoices one a time. If we call Report.Run one at a time, th...

Read more...

4 Comments

Read more... 4 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 
 
Your help is greatly appreciated, 
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 (300)

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

164

Update Analysis View: missing entries

In several cases the analysis view misses some expected entries. We shoud use the reset feature as workaround but, it is

quite annoying in organizations with several environments and companies. At the end of the month we must lose too much time to reset analysis views that should be prop...

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
New
156

Allow users to change sort order of reports

When running a report there is no ability to change the report sorting order. This function was available in the Windows Client reports. For instance: when running the Aged Accounts Receivable report you could change the sorting to be Search Name rather No. which is more useful if using standar...

Read more...

4 Comments

Read more... 4 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
Under Review
Ideas Administrator

Thank you for your feedback. We are considering adding it to our longer term roadmap. 

 

Your help is greatly appreciated, 

Mike Borg Cardona 

Product Manager, Microsoft 

155

Dynamic Filters for Reports

In Pages it's possible to use dynamic filters like %MYCUSTOMERS to create views that support users with "their" data. The advantage is the flexibility of the filter range - it's always up to date. If I use the same filter in a report (created by a job queue entry or using a report filter templat...

Read more...

5 Comments

Read more... 5 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 

Your help is greatly appreciated, 
Mike Borg Cardona
Program Manager, Microsoft  
144

Batch printing with different Custom Report Layouts

When printing reports that have a custom report layout that is configured per record (e.g. different custom "Sales Invoice" report layouts per Customer) the report must be printed per record (eg. per "Sales Invoice Header" record). Otherwise the custom report layout will be ignored. The users ...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 

Your help is greatly appreciated, 
Business Central Team

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 (300)

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
104

Include "Data Export Services" to BC Cloud

Copy the Data export Services function from Dynamics 365 to BC Cloud Hi I will strongly recommend the BC Develoment team to take a look at the dynamics 365 Platform regarding the product Data Export Services, and include this as a technology to export data from BC. Not only for reporting purpose...

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (300)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your suggestion, this functionality is currently not on our roadmap. We will keep tracking it however, to consider for our future releases.

Kind regards,
Business Central team