Forum Discussion
2 distinct data sources in one query
i have solved this-thank you no action needed
Do not merge on-prem and cloud data sources in Power Query. As you have experienced, this will result in the cloud data source requiring a gateway, forever, even after you have removed the on-prem data source.
Don't do it. Leave these data sources separate in Power Query and join them in the Power BI data model.
If you insist on doing it anyway, convert your on-prem data source to a cloud data source (via dataflow or semantic model) before the merge.
what a good solution thanks for this insight big help
ok so instead first use power query to get on prem required mysql data source and once i keep only the columns i want and i add my dax codes then save it . to power bi service right?
2then in paralell use separate power query with only dataverse data source (no gateway needed) and again establish data and publish to power bi service
3 then you are saying use data model instead? meaning within power query click the data model to do relationships between two query right? but wont i first need to have obtained the data source that is on prem into the query anyway? not clear how to do the data model you reference or what the steps are-can you send general steps please?
Create two queries in Power Query, one for your on-Prem MySQL and one for your Dataverse.
Load both queries into Power BI
Join the tables in the data model
sorry not clear here so query 1 is done- i took data soruce dataverse-did my power query transform and saved it in my power bi desktop
query 2 which has an on prem gateway is also done-again brought it into this same power bi desktop but not clear what you mean on how join table will somehow not require the one published report and dataset to not require both to be on prem for the automated daily refresh when publihsed to power bi service so can you send me a smaple scren shot pls of a generic query 1 and query 2 on what you are recmmmedning is the steps?