Forum Discussion
Solved
2 distinct data sources in one query
question power query used to get data from 2 distinct sources 1 is a query that requires and is on prem gateway(MYSQL) 2 other is a query from non prem gateway- dataverse crm no issue with query ...
i have solved this-thank you no action needed
Power Query:
Power BI:
so can you actually list the step you are doing to achieve your screen shot in power query and then power bi(not the realtionsuop) but the actual step you are doingin each one when you transform and save mysql in power query and then when you do same for dataverse(you are saying separate query right) not to add both in on query and then join in power bi table-(i did not do merge query so trying to see your exact step to achieve your solution where you sent screenshots-thank you
Please check the "data source settings" dialogue in either Power Query or Power BI. It will make the concept clearer.