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? 

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors