Hi, I'm facing following error: "Expression.Error: We cannot convert Type to Table type. Details: Value=Type Type=Type" for my query in the step "'alerts'DecisionTableWithApplCnt ": "let AllDatabases= Sql.Databases("."), Database = AllDatabases{[Name="'alerts'sDB_Leok"]}[Data], 'alerts'DecisionTable = Database {[Schema="dbo",Item="'alerts'Decision"]}[Data], 'alerts'DecisionsFor'alerts'IdFunction = ('alerts'Id) as table => Table.SelectRows('alerts'DecisionTable, ('alerts'DecisionTableRecord) => ('alerts'DecisionTableRecord['alerts'ID] = 'alerts'Id)), 'alerts'DecisionsFor'alerts'IdAndDecision = ('alerts'Id, decision) as table => Table.SelectRows('alerts'DecisionsFor'alerts'IdFunction('alerts'Id), ('alerts'DecisionTableRecord) => ('alerts'DecisionTableRecord[Decision] = decision)), 'alerts'DecisionsCountFor'alerts'IdAndDecision = ('alerts'Id, decision) as number => Table.RowCount('alerts'DecisionsFor'alerts'IdAndDecision('alerts'Id, decision)), ApplicableDecisionsCountFor'alerts'Id = ('alerts'Id) as number => 'alerts'DecisionsCountFor'alerts'IdAndDecision('alerts'Id, "Applicable"), RejectedDecisionsCountFor'alerts'Id = ('alerts'Id) as number => 'alerts'DecisionsCountFor'alerts'IdAndDecision('alerts'Id, "Rejected"), 'alerts'DecisionIDsAll = Table.SelectColumns('alerts'DecisionTable,{"'alerts'ID"}), 'alerts'DecisionIDs = Table.Distinct('alerts'DecisionIDsAll), // error comes in this line: 'alerts'DecisionTableWithApplCnt = Table.AddColumn('alerts'DecisionIDs, "ApplicableCount", (source'alerts'Record) => ApplicableDecisionsCountFor'alerts'Id(source'alerts'Record['alerts'ID])), 'alerts'DecisionTableWithApplRejCnt = Table.AddColumn('alerts'DecisionTableWithApplCnt, "RejectedCount", (source'alerts'Record) => RejectedDecisionsCountFor'alerts'Id(source'alerts'Record['alerts'ID])), ConfusingDecisions = Table.SelectRows('alerts'DecisionTableWithApplRejCnt, each [ApplicableCount] > 0 and [RejectedCount] > 0) in ConfusingDecisions " I'm using latest PowerBI Desktop version. What this error means? How to workaround it? Thanks.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Dynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db15 minutes agoNew MemberNew221Views2likes1CommentTenant and/or App/Workspace Banner messages- alerts
As a tenant admin - would like to publish banner messages or alerts as needed for the organization in the event of a data load failure, or other messaging that needs to be show to the end user on l...sue_yerly38 minutes agoNew MemberNew378Views18likes3CommentsSlicer option to show no data when no value is selected
Hello Power BI Team, Description: Currently, when the "Select All" option is enabled in a slicer, selecting it displays all related values as expected. However, when "Select All" is de-selected and...7407543 hours agoNew MemberNew3Views0likes0CommentsParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v5 hours agoCommunity ChampionNew16Views1like0CommentsAutomatically match PowerBI chart background color to Powerpoint slide background color
Export PowerBI to PowerPoint slide - Can we define the PowerBI export background color to automatically match the PowerPoint slide background color ? By Default, the PowerBI background color is Whi...jim_chan9 hours agoNew MemberNew7Views0likes0Comments