Forum Discussion

JJ51's avatar
JJ51
Frequent Visitor
1 year ago
Solved

Merged Field From Power Query Not Populating on Report Builder Side

Hey Everyone!   I have an interesting issue.  I have a few dimensional tables that I am joining to a fact table because of a unique key based on the join. I am concatenating customer, sale type, pr...
Need Help
  • JJ51's avatar
    JJ51
    1 year ago

    I ended up having to join the tables as part of my SQL query instead of after pulling into Power Query

JJ51's avatar
JJ51
Frequent Visitor
1 year ago

I ended up having to join the tables as part of my SQL query instead of after pulling into Power Query

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,JJ51 . Thank you for your reply.
    Table joins are performed in SQL queries, which is really an effective solution because it ensures that the data is properly joined before it enters the Power Query.
    It's great to see you sharing the alternatives you use in the forums.
    You can mark the alternatives you currently use as a solution,it will help more people find effective help quickly.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian



  • confecielito's avatar
    confecielito
    New Member
    1 year ago

    I had to do the same, it seems that the issue is related to the way Power BI process the merge. I tried several options and first I ruled out that the issue did not have to do with the database and the data I was using (SQL Server) when the SQL query worked perfectly in an external editor.