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...
Hey BeaBF / uzuntasgokberk ,
I tried using the following formula in creating a new column, but end up in an error.
Previously, I tried creating tables manually using the necessary columns from the table. It then worked but here, it is not working even though there is a relationship established already. VIEW_RFIS is from a database 1 and rest of the tables from different database2
Could you now please help in creating a column in VIEW_RFIS table. That way I can establish realtime data. Else, I will have to manually establish a formula using the data from the necessary column (Statusp[Name]).
Note: please ignore the hidden tables.
