Forum Discussion

JJ51's avatar
JJ51
Frequent Visitor
2 years 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