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 two fields, index, and index name), so I added them manually. Any time I'm trying to expand the result of merging I got a message, that I have to change from Direct query to Import. Is there any way to merge and expand direct query table and import table?


Thanks in advance!

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,

3 Replies

  • 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,