Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Merge direct query table with import table and expand

Hi All, I'm trying to prepare visuals based on information from Axapta. I'm using direct query(for SQL tables), but I can't use this approach for base enums (you can imagine them as a table with t...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    I would suggest you import all the tables.There's no other ways to get it work.

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

There's no better way to merge and expand direct query table and import table.Please make sure the queries are all imported(or queried at the same time). Then the merge should work.

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi  v-cherch-msft 

    Thanks for your reply, but I didn't get what is the better way exactly?

    Merge is working perfectly, the problem with expanding.

     

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous 

      I would suggest you import all the tables.There's no other ways to get it work.

      Regards,