Forum Discussion
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...
I ended up having to join the tables as part of my SQL query instead of after pulling into Power Query
I ended up having to join the tables as part of my SQL query instead of after pulling into Power Query
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.