Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/
--please don't forget to upvote
and if the reply is helpful--
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Since I installed the PBI Desktop version (May 2022) in windows 10, I am getting an error message like 'something went wrong - unexpected Object type: null' Please see below the error details. I could not be able to use DAX functions like CALCULATE, RELATED, CONCATENATE etc.
Feedback Type:
Frown (Error)
Timestamp:
2022-05-27T17:54:01.9213568Z
Local Time:
2022-05-27T13:54:01.9213568-04:00
Session ID:
90b5b265-1707-4d8d-a68f-bf500afaf634
Release:
May 2022
Product Version:
2.105.923.0 (22.05) (x64)
OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)
CLR Version:
4.8 or later [Release Number = 528040]
Peak Virtual Memory:
56.9 GB
Private Memory:
2.76 GB
Peak Working Set:
2.58 GB
IE Version:
11.1411.18362.0
User ID:
e91f76db-fe91-4de8-a0ff-a9833c46f6c6
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\dpolani\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShotffd0d38b-d206-447f-a69c-68fc7464ddd3.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\dpolani\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_useModernFormatPane
PBI_sparklines
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_lineChartError
PBI_fieldParametersSuperSwitch
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared D_items = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
D_items_table = #"Ronco Disposable Product Ltd"{[Name="D_items",Signature="table"]}[Data],
#"Merged Queries" = Table.NestedJoin(D_items_table, {"No", "Sales_Unit_of_Measure"}, D_itemunitsofmeasure, {"Item_No", "Code"}, "D_itemunitsofmeasure", JoinKind.LeftOuter),
#"Expanded D_itemunitsofmeasure" = Table.ExpandTableColumn(#"Merged Queries", "D_itemunitsofmeasure", {"Item_No", "Code", "Qty_per_Unit_of_Measure", "WSI_Case", "WSI_Length", "WSI_Width", "WSI_Height", "WSI_Cubage", "Weight", "WSI0012_External_Packing", "ItemUnitOfMeasure", "Code_Link", "ItemUnitOfMeasure_Link", "ETag"}, {"D_itemunitsofmeasure.Item_No", "D_itemunitsofmeasure.Code", "D_itemunitsofmeasure.Qty_per_Unit_of_Measure", "D_itemunitsofmeasure.WSI_Case", "D_itemunitsofmeasure.WSI_Length", "D_itemunitsofmeasure.WSI_Width", "D_itemunitsofmeasure.WSI_Height", "D_itemunitsofmeasure.WSI_Cubage", "D_itemunitsofmeasure.Weight", "D_itemunitsofmeasure.WSI0012_External_Packing", "D_itemunitsofmeasure.ItemUnitOfMeasure", "D_itemunitsofmeasure.Code_Link", "D_itemunitsofmeasure.ItemUnitOfMeasure_Link", "D_itemunitsofmeasure.ETag"})
in
#"Expanded D_itemunitsofmeasure";
shared D_postedsalesinvoices = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
D_postedsalesinvoices_table = #"Ronco Disposable Product Ltd"{[Name="D_postedsalesinvoices",Signature="table"]}[Data]
in
D_postedsalesinvoices_table;
shared D_postedsalesinvoicelines = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
D_postedsalesinvoicelines_table = #"Ronco Disposable Product Ltd"{[Name="D_postedsalesinvoicelines",Signature="table"]}[Data]
in
D_postedsalesinvoicelines_table;
shared ItemsByLocation = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
ItemsByLocation_table = #"Ronco Disposable Product Ltd"{[Name="ItemsByLocation",Signature="table"]}[Data]
in
ItemsByLocation_table;
shared D_itemunitsofmeasure = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
D_itemunitsofmeasure_table = #"Ronco Disposable Product Ltd"{[Name="D_itemunitsofmeasure",Signature="table"]}[Data]
in
D_itemunitsofmeasure_table;
shared D_slsrep_purchasers = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
D_slsrep_purchasers_table = #"Ronco Disposable Product Ltd"{[Name="D_slsrep_purchasers",Signature="table"]}[Data]
in
D_slsrep_purchasers_table;
shared #"D_slsrep_purchasers (2)" = let
Source = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Source{[Name="PRODUCTION"]}[Data],
#"Ronco Disposable Product Ltd" = PRODUCTION{[Name="Ronco Disposable Product Ltd"]}[Data],
D_slsrep_purchasers_table = #"Ronco Disposable Product Ltd"{[Name="D_slsrep_purchasers",Signature="table"]}[Data]
in
D_slsrep_purchasers_table;
shared vendorpo365_bywhse = let
Source = Sql.Database("Server9", "BIDataWarehouse"),
dbo_vendorpo365_bywhse = Source{[Schema="dbo",Item="vendorpo365_bywhse"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_vendorpo365_bywhse, each ([whse] = "MAIN"))
in
#"Filtered Rows";
shared backorder365_all = let
Source = Sql.Databases("Server9"),
BIDataWarehouse = Source{[Name="BIDataWarehouse"]}[Data],
dbo_backorder365_all = BIDataWarehouse{[Schema="dbo",Item="backorder365_all"]}[Data]
in
dbo_backorder365_all;
shared Calendar = let
Source = #date(2020, 1, 1),
Custom1 = List.Dates (Source, Number.From(DateTime.LocalNow()) - Number.From(Source), #duration(1,0,0,0)),
#"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{<!-- -->{"Column1", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{<!-- -->{"Column1", "Date"}}),
#"Inserted Year" = Table.AddColumn(#"Renamed Columns", "Year", each Date.Year([Date]), Int64.Type),
#"Inserted Month" = Table.AddColumn(#"Inserted Year", "Month", each Date.Month([Date]), Int64.Type),
#"Inserted Month Name" = Table.AddColumn(#"Inserted Month", "Month Name", each Date.MonthName([Date]), type text)
in
#"Inserted Month Name";
shared AllMeasures = 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 [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{<!-- -->{"Column1", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"})
in
#"Removed Columns";
shared productcategory = let
Source = Sql.Databases("Server9"),
BIDataWarehouse = Source{[Name="BIDataWarehouse"]}[Data],
dbo_productcategory = BIDataWarehouse{[Schema="dbo",Item="productcategory"]}[Data]
in
dbo_productcategory;
shared vendorpo365_bywhse_west = let
Source = Sql.Databases("Server9"),
BIDataWarehouse = Source{[Name="BIDataWarehouse"]}[Data],
dbo_vendorpo365_bywhse_west = BIDataWarehouse{[Schema="dbo",Item="vendorpo365_bywhse_west"]}[Data],
#"Removed Duplicates" = Table.Distinct(dbo_vendorpo365_bywhse_west, {"whitemno"})
in
#"Removed Duplicates";
shared inventory = let
Source = Sql.Databases("Server9"),
BIDataWarehouse = Source{[Name="BIDataWarehouse"]}[Data],
dbo_inventory = BIDataWarehouse{[Schema="dbo",Item="inventory"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_inventory, each ([Location_Code] = "MAIN"))
in
#"Filtered Rows";
shared usagel6m = let
Source = Sql.Databases("Server9"),
BIDataWarehouse = Source{[Name="BIDataWarehouse"]}[Data],
dbo_usagel6m = BIDataWarehouse{[Schema="dbo",Item="usagel6m"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_usagel6m, each ([location_code] = "MAIN"))
in
#"Filtered Rows";
shared #"productcategory (2)" = let
Source = Sql.Database("server9", "BIDataWarehouse"),
dbo_productcategory = Source{[Schema="dbo",Item="productcategory"]}[Data]
in
dbo_productcategory;
shared salestotal_vqm_all_currentyear = let
Source = Sql.Database("server9", "BIDataWarehouse"),
dbo_salestotal_vqm_all_currentyear = Source{[Schema="dbo",Item="salestotal_vqm_all_currentyear"]}[Data]
in
dbo_salestotal_vqm_all_currentyear;
shared #"backorder365_all (2)" = let
Source = Sql.Database("server9", "BIDataWarehouse"),
dbo_backorder365_all = Source{[Schema="dbo",Item="backorder365_all"]}[Data]
in
dbo_backorder365_all;
shared connecting_table_ds = let
Source = Sql.Database("server9", "BIDataWarehouse"),
dbo_connecting_table_ds = Source{[Schema="dbo",Item="connecting_table_ds"]}[Data]
in
dbo_connecting_table_ds;
Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/
--please don't forget to upvote
and if the reply is helpful--