Forum Discussion
How to transform data from different databases with different security and schemes?
Hi AlexNL,
Thank you for reaching out in Microsoft Community Forum.
You're right: currently, Power BI doesn't support combining tables from different sources (like UNION) directly in Power Query within a composite model. While there are some workarounds (like using DAX or external views), there's no true "Power BI only" solution for this at the moment.
This is a great feature idea, and I’d definitely recommend submitting it on the https://community.fabric.microsoft.com/t5/Ideas/ct-p/PBI_Comm_Ideas - it's feedback like this that helps drive improvements.
Please continue using Microsoft Community Forum.If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
Hi Anonymous
Unfortunately there is no Power BI only solution for it according to the replies.
Hi AlexNL,
Thank you for reaching out in Microsoft Community Forum.
You're right: currently, Power BI doesn't support combining tables from different sources (like UNION) directly in Power Query within a composite model. While there are some workarounds (like using DAX or external views), there's no true "Power BI only" solution for this at the moment.
This is a great feature idea, and I’d definitely recommend submitting it on the https://community.fabric.microsoft.com/t5/Ideas/ct-p/PBI_Comm_Ideas - it's feedback like this that helps drive improvements.
Please continue using Microsoft Community Forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
Thank you for reply. The answer is clear. I will submit is as a feature idea. 🙂
Hi AlexNL,
Thank you for submitting the feature idea. if my posts are helpful. please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.