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
ok so step 1 power bi desktop step 2 get on prem data source 1- step transform and do steps in power query like normal to edit data etc step 4 save in power query and apply to desktop power step 5 do same for non prom data source in its onw power query separate- step 6 then open one of the 2 power bi desktop and from there join the table in the data model step 7 then publish to power bi service step 8 service should then allow refresh without requiring both to be on prem gateway for refresh ? ok let me try this thanks
This is all done in the same Power BI Desktop PBIX.