Feedback Type:
Frown (Error)

Timestamp:
2022-09-20T00:46:33.2603684Z

Local Time:
2022-09-19T20:46:33.2603684-04:00

Session ID:
f058140c-21aa-4ba1-b4f5-ad4ab0bffeb1

Release:
September 2022

Product Version:
2.109.642.0 (22.09) (x64)

Error Message:
There's not enough memory to complete this operation. Please try again later when there may be more memory available.

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
54.2 GB

Private Memory:
514 MB

Peak Working Set:
960 MB

IE Version:
11.789.19041.0

User ID:
dfcd941a-1106-49a2-84fc-b0728e3491d9

Workbook Package Info:
1* - en-US, Query Groups: 3, fastCombine: Enabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\bkrolicki\Microsoft\Power BI Desktop Store App\FrownSnapShot3f153f9e-8bea-4c0c-99ba-6034d8e31b15.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\bkrolicki\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_enableWebView2
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

Formulas:


section Section1;

shared #"Account Groups" = let
    Source = PowerBI.Dataflows(null),
    #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6" = Source{[workspaceId="46caefd8-72e8-4bec-8bd0-0fc4e142ade6"]}[Data],
    #"8463d485-9bbd-4435-ba46-51e767f3dfc4" = #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6"{[dataflowId="8463d485-9bbd-4435-ba46-51e767f3dfc4"]}[Data],
    #"Account Groups1" = #"8463d485-9bbd-4435-ba46-51e767f3dfc4"{[entity="Account Groups"]}[Data]
in
    #"Account Groups1";

shared #"Account Groups RT" = let
    Source = PowerBI.Dataflows(null),
    #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6" = Source{[workspaceId="46caefd8-72e8-4bec-8bd0-0fc4e142ade6"]}[Data],
    #"8463d485-9bbd-4435-ba46-51e767f3dfc4" = #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6"{[dataflowId="8463d485-9bbd-4435-ba46-51e767f3dfc4"]}[Data],
    #"Account Groups RT1" = #"8463d485-9bbd-4435-ba46-51e767f3dfc4"{[entity="Account Groups RT"]}[Data]
in
    #"Account Groups RT1";

shared #"Chart of Accounts" = let
    Source = PowerBI.Dataflows(null),
    #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6" = Source{[workspaceId="46caefd8-72e8-4bec-8bd0-0fc4e142ade6"]}[Data],
    #"8463d485-9bbd-4435-ba46-51e767f3dfc4" = #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6"{[dataflowId="8463d485-9bbd-4435-ba46-51e767f3dfc4"]}[Data],
    #"Chart of Accounts1" = #"8463d485-9bbd-4435-ba46-51e767f3dfc4"{[entity="Chart of Accounts"]}[Data]
in
    #"Chart of Accounts1";

shared Dates = let
    Source = PowerBI.Dataflows(null),
    #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6" = Source{[workspaceId="46caefd8-72e8-4bec-8bd0-0fc4e142ade6"]}[Data],
    #"8463d485-9bbd-4435-ba46-51e767f3dfc4" = #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6"{[dataflowId="8463d485-9bbd-4435-ba46-51e767f3dfc4"]}[Data],
    Dates1 = #"8463d485-9bbd-4435-ba46-51e767f3dfc4"{[entity="Dates"]}[Data]
in
    Dates1;

shared #"GL Detail" = let
    Source = PowerBI.Dataflows(null),
    #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6" = Source{[workspaceId="46caefd8-72e8-4bec-8bd0-0fc4e142ade6"]}[Data],
    #"8463d485-9bbd-4435-ba46-51e767f3dfc4" = #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6"{[dataflowId="8463d485-9bbd-4435-ba46-51e767f3dfc4"]}[Data],
    #"GL Detail1" = #"8463d485-9bbd-4435-ba46-51e767f3dfc4"{[entity="GL Detail"]}[Data],
    #"Inserted Merged Column" = Table.AddColumn(#"GL Detail1", "Jrnl Nbr | Comment (Descr)", each Text.Combine({[Journal Nbr], [Comment]}, "|"), type text)
in
    #"Inserted Merged Column";

shared Projections = let
    Source = PowerBI.Dataflows(null),
    #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6" = Source{[workspaceId="46caefd8-72e8-4bec-8bd0-0fc4e142ade6"]}[Data],
    #"8463d485-9bbd-4435-ba46-51e767f3dfc4" = #"46caefd8-72e8-4bec-8bd0-0fc4e142ade6"{[dataflowId="8463d485-9bbd-4435-ba46-51e767f3dfc4"]}[Data],
    Projections1 = #"8463d485-9bbd-4435-ba46-51e767f3dfc4"{[entity="Projections"]}[Data]
in
    Projections1;

shared Budgets = let
    Source = Projections,
    #"Renamed Columns" = Table.RenameColumns(Source,{{"Account", "Account #"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Amount] <> 0)),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Amount", Currency.Type}})
in
    #"Changed Type";

shared COA = let
    Source = #"Chart of Accounts",
    #"Renamed Columns" = Table.RenameColumns(Source,{{"GL Number", "Account #"}, {"Level 2", "Group"}, {"Level 3", "Sub-Group"}, {"Level 1 Sort", "Class Order"}, {"Level 2 Sort", "Group Order"}, {"Level 3 Sort", "Sub-Group Order"}, {"Level 4", "Account Name"}, {"Level 4 w GL Nbr", "Acct Name w Acct #"}, {"BS or PL", "Statement"}, {"Level 4 Sort", "Account Name Order"}, {"P&L RT Sort", "P&L RT Order"}}),
    #"Added GL Display column" = Table.AddColumn(#"Renamed Columns", "GL Display", each 2),
    #"Replaced PL w IS" = Table.ReplaceValue(#"Added GL Display column","PL","IS",Replacer.ReplaceText,{"Statement"}),
    #"Added Conditional Column for Class" = Table.AddColumn(#"Replaced PL w IS", "Class", each if [Level 1] = "ASSET" then "Assets" else if [Level 1] = "COST OF SALES" then "Cost of Sales" else if [Level 1] = "EXPENSES" then "Expenses" else if [Level 1] = "LIABILITIES AND EQUITY" then "Liabilities & Equity" else if [Level 1] = "OTHER (INCOME)/EXPENSE" then "Other (Income)/Expense" else if [Level 1] = "REVENUE" then "Revenues" else "Error"),
    #"Added Cash Flow Class column null" = Table.AddColumn(#"Added Conditional Column for Class", "Cash Flow Class", each null),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Cash Flow Class column null",{"Account #", "Statement", "P&L RT", "Group", "Sub-Group", "Account Name", "Acct Name w Acct #", "P&L RT Order", "Class Order", "Group Order", "Sub-Group Order", "Account Name Order", "GL Display", "Class", "Cash Flow Class"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Account #", type text}, {"Account Name", type text}, {"Acct Name w Acct #", type text}, {"Class", type text}, {"Group", type text}, {"Sub-Group", type text}, {"Cash Flow Class", type text}, {"P&L RT Order", Int64.Type}, {"Class Order", Int64.Type}, {"Group Order", Int64.Type}, {"Sub-Group Order", Int64.Type}, {"Account Name Order", Int64.Type}, {"Statement", type text}, {"GL Display", Int64.Type}})
in
    #"Changed Type";

shared GLDisplay = let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfIvSM3LzEtXcErMScxLTlWK1YlWMgKKO5cWFaXmlSiEFCXmFScml2Tm5xUrxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Display Order" = _t, #"Current Transactions#(lf)Current Transactions#(lf)" = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"Current Transactions#(lf)Current Transactions#(lf)", "GL Period"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Display Order", Int64.Type}, {"GL Period", type text}})
in
    #"Changed Type";

shared SCF = let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jZNNb8IwDIb/SsQJJJBo+ZA4AmMTEgKEthPjEFoPMlGHJQGJfz+nXkspdOKQt5JjP/FHvV7XFkcxtBacaImxtPtaszbeS9yBUJgb6CNG8iAxAnKbYKxwR/auPwOWTfMGNcUzoNPmQreLIxjpKEQMI6fOyimwZC66BP70WEqkFUSgznJ7SIMqWLdOKa3L4mljeVejf9w+zumBOfQnYCkD5xpb/0MzDzF1kGS4ge9bEKa4F9h60kxT5DuYhG5eFVK371C5i8gdyNrxJ2Ap8PJeVfftai7y0v71WTxv8nNS7lKdFd8LLj+hodosqZDFQ5afp3Y77M+uM6jIaU5tnWKkExD1mba2Ib6MTrJqNOYT/pMSvDCPqgfK8wh4FPk8JtIgRVmf6skYKqi69jtYpzTcAmwFTiqE+InUlkZpI5ZAn1gM4+8syw4L/4R23+JdrVzaN0D/DsSi/mEhbmRL22PJMZQOPrH53q2w+gHLZvML", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Class = _t, Heading = _t, Subheading = _t, #"Heading Level" = _t, #"SubHead Level" = _t, #"SubHead Sort" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Class", type text}, {"Heading", type text}, {"Subheading", type text}, {"Heading Level", Int64.Type}, {"SubHead Level", Int64.Type}, {"SubHead Sort", Int64.Type}})
in
    #"Changed Type";

shared Transactions = let
    Source = #"GL Detail",
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Account", "Date", "Journal Nbr", "SequenceNo", "BatchNo", "Comment", "Amount"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Account", "Account #"}}),
    #"Inserted First Characters" = Table.AddColumn(#"Renamed Columns", "Source Journal", each Text.Start([Journal Nbr], 2), type text),
    #"Reordered Columns" = Table.ReorderColumns(#"Inserted First Characters",{"Account #", "Date", "Journal Nbr", "Source Journal", "SequenceNo", "BatchNo", "Comment", "Amount"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Reordered Columns",{{"Amount", Currency.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Journal Nbr"}, {{"Data", each _, type table [#"Account #"=nullable text, Date=nullable date, Journal Nbr=nullable text, Source Journal=text, SequenceNo=nullable text, BatchNo=nullable text, Comment=nullable text, Amount=nullable number]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"JE Line",1)),
    #"Removed Other Columns2" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns2", "Custom", {"Account #", "Date", "Journal Nbr", "Source Journal", "SequenceNo", "BatchNo", "Comment", "BatchNo(2)", "Jrnl Nbr | Comment (Descr)", "Amount", "JE Line"}, {"Account #", "Date", "Journal Nbr", "Source Journal", "SequenceNo", "BatchNo", "Comment", "BatchNo(2)", "Jrnl Nbr | Comment (Descr)", "Amount", "JE Line"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Account #", type text}, {"Journal Nbr", type text}, {"Source Journal", type text}, {"SequenceNo", type text}, {"BatchNo", type text}, {"Comment", type text}, {"BatchNo(2)", type text}, {"Jrnl Nbr | Comment (Descr)", type text}, {"JE Line", type text}, {"Amount", Currency.Type}, {"Date", type date}}),
    #"Inserted Merged Column" = Table.AddColumn(#"Changed Type1", "Lnk_JEDetail", each Text.Combine({[Journal Nbr], [JE Line]}, "-"), type text),
    #"Removed Other Columns1" = Table.SelectColumns(#"Inserted Merged Column",{"Account #", "Date", "Comment", "Journal Nbr", "Source Journal", "SequenceNo", "BatchNo", "Amount", "Lnk_JEDetail"})
in
    #"Removed Other Columns1";

shared #"Product Lines" = let
    Source = #"Chart of Accounts",
    #"Removed Other Columns" = Table.SelectColumns(Source,{"GL Number", "Product Line"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"GL Number", "Account #"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Product Line w Acct #", each if [Product Line]<> "" 
then [Product Line]&" ("&[#"Account #"]&")" 
else ""),
    #"Filtered Rows" = Table.SelectRows(#"Added Custom", each true),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Product Line w Acct #", type text}})
in
    #"Changed Type";

shared Calendar = let
    Source = Dates,
    #"Renamed Columns" = Table.RenameColumns(Source,{{"MonthOfYear", "Month"}})
in
    #"Renamed Columns";

shared #"Company Name" = "Jardine Associates" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true];

shared _Helpers = let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Measures = _t])
in
    Source;

shared EAMonths = let
    Source = Calendar,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Month", "Month Name", "MonthShortName"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns"),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Duplicates",{{"Month", Int64.Type}, {"Month Name", type text}, {"MonthShortName", type text}})
in
    #"Changed Type";

shared JEDetail = let
    Source = Transactions,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Comment", "Journal Nbr", "Lnk_JEDetail"}),
    #"Removed Duplicates1" = Table.Distinct(#"Removed Other Columns", {"Lnk_JEDetail"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates1",{{"Comment", "Description"}}),
    #"Inserted First Characters" = Table.AddColumn(#"Renamed Columns", "Source Journal", each Text.Start([Lnk_JEDetail], 2), type text)
in
    #"Inserted First Characters";