Feedback Type:
Frown (Error)

Timestamp:
2019-05-24T17:59:40.0174018Z

Local Time:
2019-05-24T13:59:40.0174018-04:00

Session ID:
0ec786cd-daa4-4be0-b8d8-4e6d4e393dd3

Release:
May 2019

Product Version:
2.69.5467.1751 (19.05) (x64)

Error Message:
Not a legal OleAut date.. The exception was raised by the IDataReader interface.

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

CLR Version:
4.7 or later [Release Number = 461814]

Peak Virtual Memory:
34 GB

Private Memory:
472 MB

Peak Working Set:
605 MB

IE Version:
11.1146.16299.0

User ID:
0d076e58-0d45-482a-8feb-881ca9ce8361

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Composite

Snapshot Trace Logs:
C:\Users\wdurke\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot856891439.zip

Performance Trace Logs:
C:\Users\wdurke\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_improvedFilterExperience
PBI_qnaLiveConnect
PBI_keyDrivers

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared BASIC_SUMMARY = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling", [Query="SELECT c.SZ_DESCRIPTION as Contract,#(lf)#(tab)#(tab)   YEAR(c.DT_START) as Year,#(lf)#(tab)#(tab)   SUM(l.N_PLANNED_AMOUNT) as Planned,#(lf)#(tab)#(tab)   SUM(l.N_BUDGET_AMOUNT) as Budget,#(lf)#(tab)#(tab)   SUM(l.N_PAID_AMOUNT) as Paid#(lf)#(lf)FROM #(lf)#(tab)[IT.MaintenanceBilling].dbo.VENDOR v#(lf)#(tab) INNER JOIN [IT.MaintenanceBilling].dbo.CONTRACT c#(lf)#(tab)#(tab)ON v.N_VENDOR_PK = c.N_VENDOR_FK#(lf)#(tab) INNER JOIN [IT.MaintenanceBilling].dbo.INVOICE i#(lf)#(tab)#(tab)ON c.N_CONTRACT_PK = i.N_CONTRACT_FK#(lf)#(tab) INNER JOIN [IT.MaintenanceBilling].dbo.LINE_ITEM l#(lf)#(tab)#(tab)ON i.N_INVOICE_PK = l.N_INVOICE_FK#(lf)#(lf)GROUP BY c.SZ_DESCRIPTION, c.DT_START", MultiSubnetFailover=true])
in
    Source;

shared ACTION = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_ACTION = Source{[Schema="dbo",Item="ACTION"]}[Data]
in
    dbo_ACTION;

shared COMMENT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_COMMENT = Source{[Schema="dbo",Item="COMMENT"]}[Data]
in
    dbo_COMMENT;

shared CONTACT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_CONTACT = Source{[Schema="dbo",Item="CONTACT"]}[Data]
in
    dbo_CONTACT;

shared CONTRACT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_CONTRACT = Source{[Schema="dbo",Item="CONTRACT"]}[Data]
in
    dbo_CONTRACT;

shared DEPARTMENT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_DEPARTMENT = Source{[Schema="dbo",Item="DEPARTMENT"]}[Data]
in
    dbo_DEPARTMENT;

shared FILE_STORAGE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_FILE_STORAGE = Source{[Schema="dbo",Item="FILE_STORAGE"]}[Data]
in
    dbo_FILE_STORAGE;

shared INVOICE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_INVOICE = Source{[Schema="dbo",Item="INVOICE"]}[Data]
in
    dbo_INVOICE;

shared LINE_ITEM = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_LINE_ITEM = Source{[Schema="dbo",Item="LINE_ITEM"]}[Data],
    #"Renamed Columns" = Table.RenameColumns(dbo_LINE_ITEM,{{"N_PAID_AMOUNT", "Paid"}})
in
    #"Renamed Columns";

shared ONE_SOLUTION_VENDOR_ADDR_CODE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_ONE_SOLUTION_VENDOR_ADDR_CODE = Source{[Schema="dbo",Item="ONE_SOLUTION_VENDOR_ADDR_CODE"]}[Data]
in
    dbo_ONE_SOLUTION_VENDOR_ADDR_CODE;

shared REF_CONTRACT__X__COMMENT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_CONTRACT__X__COMMENT = Source{[Schema="dbo",Item="REF_CONTRACT__X__COMMENT"]}[Data]
in
    dbo_REF_CONTRACT__X__COMMENT;

shared REF_CONTRACT__X__FILE_STORAGE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_CONTRACT__X__FILE_STORAGE = Source{[Schema="dbo",Item="REF_CONTRACT__X__FILE_STORAGE"]}[Data]
in
    dbo_REF_CONTRACT__X__FILE_STORAGE;

shared REF_INVOICE__X__COMMENT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_INVOICE__X__COMMENT = Source{[Schema="dbo",Item="REF_INVOICE__X__COMMENT"]}[Data]
in
    dbo_REF_INVOICE__X__COMMENT;

shared REF_INVOICE__X__FILE_STORAGE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_INVOICE__X__FILE_STORAGE = Source{[Schema="dbo",Item="REF_INVOICE__X__FILE_STORAGE"]}[Data]
in
    dbo_REF_INVOICE__X__FILE_STORAGE;

shared REF_INVOICE__X__TRACKING_TAG = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_INVOICE__X__TRACKING_TAG = Source{[Schema="dbo",Item="REF_INVOICE__X__TRACKING_TAG"]}[Data]
in
    dbo_REF_INVOICE__X__TRACKING_TAG;

shared REF_LINE_ITEM__X__COMMENT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_LINE_ITEM__X__COMMENT = Source{[Schema="dbo",Item="REF_LINE_ITEM__X__COMMENT"]}[Data]
in
    dbo_REF_LINE_ITEM__X__COMMENT;

shared REF_LINE_ITEM__X__FILE_STORAGE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_LINE_ITEM__X__FILE_STORAGE = Source{[Schema="dbo",Item="REF_LINE_ITEM__X__FILE_STORAGE"]}[Data]
in
    dbo_REF_LINE_ITEM__X__FILE_STORAGE;

shared REF_TRACKING_TAG = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_TRACKING_TAG = Source{[Schema="dbo",Item="REF_TRACKING_TAG"]}[Data]
in
    dbo_REF_TRACKING_TAG;

shared REF_VENDOR__X__COMMENT = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_VENDOR__X__COMMENT = Source{[Schema="dbo",Item="REF_VENDOR__X__COMMENT"]}[Data]
in
    dbo_REF_VENDOR__X__COMMENT;

shared REF_VENDOR__X__FILE_STORAGE = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_REF_VENDOR__X__FILE_STORAGE = Source{[Schema="dbo",Item="REF_VENDOR__X__FILE_STORAGE"]}[Data]
in
    dbo_REF_VENDOR__X__FILE_STORAGE;

shared sysdiagrams = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_sysdiagrams = Source{[Schema="dbo",Item="sysdiagrams"]}[Data]
in
    dbo_sysdiagrams;

shared VENDOR = let
    Source = Sql.Database("wisc10\dv", "IT.MaintenanceBilling"),
    dbo_VENDOR = Source{[Schema="dbo",Item="VENDOR"]}[Data]
in
    dbo_VENDOR;