calls to #sections and #shared doesn't work for model upload

[aminakov]

While perfectly working for PQ itself, I cannot use them if any results go to Model. Why is that? It seems rediculous...

[v-yuta-msft]

@aminakov ,

Could you please share spme sample data and the M code?

Regards,

Jimmy Tao

[aminakov]

Pls create 2 queries, first one:

= #sections[Section1][ttt]

Second query name ttt and the body of query is any value, e.g. 1.

Ensure that all is ok while you in PQ UI.

Make the first query uploadable to model.

While refreshing the model, you'll get Ole error.

[aminakov]

Just checked - in Excel all works fine, regardless of target - model or / and table. You defenitely have a bug in the current release of PBID, guys :-). In some cases PBID rases an OLe error, and in some cases just crashes silently.

[aminakov]

Is it possible to have any sort of reaction on this post? Thank you very much in advance.