Forum Discussion

aminakov's avatar
aminakov
Frequent Visitor
7 years ago

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...

Need Help

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    aminakov ,

     

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

     

    Regards,

    Jimmy Tao

    • aminakov's avatar
      aminakov
      Frequent Visitor
      7 years ago

      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's avatar
        aminakov
        Frequent Visitor
        7 years ago

        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.