cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xander2121
Frequent Visitor

Step folding Unknown indicator error behind?

Hello everyone,

 

In the Step foldin indicators there is an "Unknown" indicator which represents absence of query plan due to an error. How do I find out that error? 

1 ACCEPTED SOLUTION
jjgb
Microsoft
Microsoft

Hi @xander2121

 

The step indicators are calculated by using the query plan. In "M", the query plan can be obtained by calling Value.Expression(Value.Optimize(...)) on the affected step.

 

For example, a known bug (under investigation) that will produce an "Unknown" step indicator is this:

 

let
  Source = Sql.Database("some_server""some_database", [CreateNavigationProperties = false]),
  Navigation = Source{[Schema = "dbo", Item = "Tags"]}[Data],
  #"Removed top rows" = Table.Skip(Navigation, 4)
in
  #"Removed top rows"

 

I can obtain the error message by adding a new step that obtains the query plan for the affected step:

let
  Source = Sql.Database("some_server""some_database", [CreateNavigationProperties = false]),
  Navigation = Source{[Schema = "dbo", Item = "Tags"]}[Data],
  #"Removed top rows" = Table.Skip(Navigation, 4),
  QueryPlan = Value.Expression(Value.Optimize(#"Removed top rows"))
in
  QueryPlan
 
Hope this helps. If you can, please share your query so we can track this as a bug.
 
Regards,
Jorge

View solution in original post

2 REPLIES 2
jjgb
Microsoft
Microsoft

Hi @xander2121

 

The step indicators are calculated by using the query plan. In "M", the query plan can be obtained by calling Value.Expression(Value.Optimize(...)) on the affected step.

 

For example, a known bug (under investigation) that will produce an "Unknown" step indicator is this:

 

let
  Source = Sql.Database("some_server""some_database", [CreateNavigationProperties = false]),
  Navigation = Source{[Schema = "dbo", Item = "Tags"]}[Data],
  #"Removed top rows" = Table.Skip(Navigation, 4)
in
  #"Removed top rows"

 

I can obtain the error message by adding a new step that obtains the query plan for the affected step:

let
  Source = Sql.Database("some_server""some_database", [CreateNavigationProperties = false]),
  Navigation = Source{[Schema = "dbo", Item = "Tags"]}[Data],
  #"Removed top rows" = Table.Skip(Navigation, 4),
  QueryPlan = Value.Expression(Value.Optimize(#"Removed top rows"))
in
  QueryPlan
 
Hope this helps. If you can, please share your query so we can track this as a bug.
 
Regards,
Jorge
Eyelyn9
Community Support
Community Support

Hi @xander2121 ,

 

Could you please provide some details like when the error occurs and screenshots to help us clarify your scenario?

 

Best Regards,
Eyelyn Qin

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors