Forum Discussion
Dataflow with different data sources fails
I have a dataflow where I would like to combine 2 tables from 2 different datasources with a merge query (merge as new), however I keep getting errors with the connections. Here is the situation:...
where I would like to combine 2 tables from 2 different datasources with a merge query
Don't do that, especially not in a dataflow. Leave the tables alone and combine them in the Power BI data model of the dataset that consumes the dataflow.
What is your reasoning for pulling Dataverse information into a dataflow?