Merge direct query table with import table and expand

[Anonymous]

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!

[v-cherch-msft]

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]

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 · Accepted solution]

Hi @Anonymous 

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

Regards,