Forum Discussion
Unable to combine data - revisited
Thanks Kelly.
I've given a try the solution proposed here and to my suprise it works.
Up to now I was convinced that every data source has to be created in a separate PQ table (this was also the solution in Patrick's video). But the working solution (in Power BI service) require mixing Excel data and sql server data in one PQ table.
So I can confirm that if we prepare a selection table in Excel (stored locally or on OneDrive) and then use this table (after small transformation) as a condition in sql server query where clause the solution will work when both sources will be read in the same PQ table.
Regards
Community SupportHi AdamJustyn ，
Could you pls make a copy of the codes in the advanced editor?
Best Regards,
Kelly
Thanks Kelly.
I've given a try the solution proposed here and to my suprise it works.
Up to now I was convinced that every data source has to be created in a separate PQ table (this was also the solution in Patrick's video). But the working solution (in Power BI service) require mixing Excel data and sql server data in one PQ table.
So I can confirm that if we prepare a selection table in Excel (stored locally or on OneDrive) and then use this table (after small transformation) as a condition in sql server query where clause the solution will work when both sources will be read in the same PQ table.
Regards
- v-kelly-msft
Hi AdamJustyn ,
Good point,thanks for sharing!
So your issue is solved now?If so,could you pls mark the reply as answered to close it?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!