Forum Discussion
Merge and expand in direct query
Hello Community, I would like to have your assistance in an error that I encountered in direct query mode. I know this is not supported in direct query mode. Atleast, could someone please help me...
Max19 Hi!
Instead of merging the tables, use Power BI’s Manage Relationships feature to create a relationship between Table 1 and Table 2 on the Id and Status Id columns.
With the relationship established, you can use DAX formulas to reference and display related values from Table 2 in visuals. This approach allows you to keep the tables separate but still retrieve relevant data for your analysis without merging.
as you can see, in the same visual i've used the ID of Table1 and a Field of Table2.
if it's ok, please accept my answer as solution.
BBF
Hi BeaBF, uzuntasgokberk
The reason I am asking this is, later I will have to do some other transformations like creating custom and conditional columns.
Any comments on this?