question

DilliPolaniRonco-3462 avatar image
0 Votes"
DilliPolaniRonco-3462 asked DSPatrick answered

Something went wrong in PBI new version

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-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

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 145510-image.png if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.