Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @Anonymous
I would suggest you import all the tables.There's no other ways to get it work.
Regards,
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,
Thanks for your reply, but I didn't get what is the better way exactly?
Merge is working perfectly, the problem with expanding.
Hi @Anonymous
I would suggest you import all the tables.There's no other ways to get it work.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |