Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge 2 column in Direct Query

I have 2 table tbl1 & tbl2. Both the table have "ProductID" & "ProductVersion" column. For making the relationship between both the tables, I need to link "ProductID" & "ProductVersion" columns in bo...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

     

    I have waited for the Feb release before making my point on this thread and now as the Feb release has arrived, I have tried my hands on it.

     

    It too contains the issue of concatenating columns using Direct Query Mode which I have reported to them and hope that this will be fixed in March release.

    http://community.powerbi.com/t5/Issues/concatenation-of-column-not-working-in-Direct-Query-with-vertica/idi-p/356279

     

    Though I know that merging columns in DB will work in PBI, I am not going to do it because I don't think that will be a good idea.

     

    Thanks for having discussion with me on this Thread. I enjoyed getting idead from you.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

I am using version 2.51 for my development purpose in which the provided DAX query is not working.

 

I have also tried Version 2.54 (January release) but I want to exclude that version for the discussion in thread because Direct Query in 2.54 version is not working with my DB i.e. Vertica.

 

Thanks!!!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

I have no Vertica environment, I make a test using SQL Server database and the DAX works well. 

You are using October update of Power BI Desktop, have you tried November and December versions of Power BI Desktop?

Regards,
Lydia