Forum Discussion
aminakov
7 years agoFrequent Visitor
calls to #sections and #shared doesn't work for model upload
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
Community Support
7 years ago- aminakov7 years agoFrequent Visitor
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.
- aminakov7 years agoFrequent Visitor
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.
- aminakov7 years agoFrequent Visitor
Is it possible to have any sort of reaction on this post? Thank you very much in advance.