Forum Discussion

AlexNL's avatar
AlexNL
Advocate II
1 year ago
Solved

How to transform data from different databases with different security and schemes?

Hi guys, Question about Power BI Desktop concerning developing semantic layers. Hopefully somebody out there can help me.   If you want to combine data from two different databases that are hosted...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

AlexNL's avatar
AlexNL
Advocate II
1 year ago

Thank you for answer. I understand answer 2 and 3, but I am looking for a Power BI only solution. I am afraid it is not possible. To be sure I made a simple picture just to be sure you understand the question. THANK YOU.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AlexNL,

Thanks for reaching out in Microsoft Community Forum.

Please follow below to resolve the error;

1.If Power Query doesn’t support UNION, you can create a new table in Power BI using DAX:
CombinedTable = UNION('Table1', 'Table2')

2.If the data sources are cloud-based, using Power BI Dataflows might allow pre-aggregation before the model loads.

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'. if it was helpful. help other members find it more easily.

Regards,
Pavan.