Forum Discussion

aarvidsson's avatar
aarvidsson
Most Valuable Professional
9 years ago
Solved

Stack overflow after expanding

Hi guys,   I'm running into a stack overflow error after expanding a #shared table. I've done this:   1. I created three excel files with two columns each: name and value. These excel files conta...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi aarvidsson,

     

    I can reproduce the issue on my side, and reported it internally. Will keep you updated once get any feedback.

     

    Best Regards,
    Qiuyun Yu

GuyInACube's avatar
GuyInACube
Administrator
9 years ago

How many items do you have in the sheets? I tried to reproduce the issue. I created three product spreadsheets with just name and value columns.  Here was the shared query. (I'm using the January Power BI Desktop.

 

let
Query = #shared,
Converted = Record.ToTable(Query),
KeptRows = Table.FirstN(Converted ,3),
ExpandedItems = Table.ExpandTableColumn(KeptRows, "Value", {"Name", "Value"}, {"Name.1", "Value.1"})
in
ExpandedItems

 

aarvidsson's avatar
aarvidsson
Most Valuable Professional
9 years ago

Hi Adam,

 

The problem won't show itself until you close and apply back to PBI desktop. Then the resulting query will be blank. This is probably due to some scoping issue with #shared and #section (and equally probably by design), but I can't get my head around how it's supposed to work. In your case, using FirstN, I'm fairly sure you'll hit the original but as well (stack overflow), but try a range or a last N and you'll see the problem with the blank query...