Bug: Section1 results not loaded to data model

[ImkeF]

The result of: Record.ToTable(#sections[Section1]) are returned correctly in the query editor, but not loaded to the data model. There, only the value of the current query will be returned.

In Excel, this works fine, so both results are the same: A table with all queries in the current file.

[v-qiuyu-msft]

Hi @ImkeF,

Would you please share a sample for us to reproduce this issue? Detail steps or sample pbix file is better.

Best Regards,
QiuyunYu

[ImkeF]

Thank you!

https://1drv.ms/u/s!AP_aAl3fXRbehatZ

"TableWith3Rows" has the correct 3 rows in the query editor, but only 1 row will be loaded to the data model.

[v-qiuyu-msft]

Hi @ImkeF,

I have reported this issue internally: CRI 43918000. Will update here if I get any response. 

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @ImkeF,

The response from PG is:

This is currently by design and is not expected to change.

Best Regards,
Qiuyun Yu