265
My customer recently got updated to V 20 and now cannot export data from analysis views as he was before.
He can export but it no longer looks the same.
Does anyone know if there were changes to that? Since I can't see what he was doing before the update, I cannot tell if there was a change or if he was doing something different.
I cannot seem to find anything on it
Any help or thoughts appreciated
Hello,
Unfortunately, the experience you have with Export to Excel on the page mentioned is no longer supported in SaaS in Dynamics 365 Business Central 2022 Wave 1 (BC20.x). The code behind this can be found here. This is indeed a change added in BC20 (Visible = Not IsSaaS):
page 9249 "Analysis by Dimensions Matrix"
actions
{
area(navigation)
{
group("&Actions")
{
Caption = '&Actions';
Image = "Action";
action(ExportToExcel)
{
ApplicationArea = Dimensions;
Caption = 'Export to Excel';
Image = ExportToExcel;
Promoted = true;
PromotedCategory = Process;
Visible = Not IsSaaS;
ToolTip = 'Export the information in the analysis report to Excel.';
In BC20 OnPrem the Export to Excel is visible because it is OnPrem:
An idea was created by another partner:
The technical reason is the following:
This has to do with us not being able to support .NET/COM Excel components in SaaS, hence the solution we have now. We export you all the data via the Open in Excel button (right hand side) however, you need to create pivot table on your own as current Excel libraries do not support that.
Hope this explains the change appreciating the fact that you do not like the answer.
Thank you.
LB,
There have been several issues reported about v20, which is why they have halted the v20 updates. Please submit an URGENT support ticket to Microsoft so they address with the others.
Hope this helps.
Thanks,
Steve
Share
Report
All responses (
Answers (
