Forum Discussion

jj1's avatar
jj1
Helper II
1 year ago
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 ...
General Comment
  • jj1's avatar
    jj1
    1 year ago

    i have solved this-thank you no action needed

lbendlin's avatar
lbendlin
Super User
1 year ago

Power Query:

 

Power BI:

 

jj1's avatar
jj1
Helper II
1 year ago

sorry still an issue here-again ive used power query and service many times just this is first time to do with one on prem and one non on prem and yes goal is when publish not require both to be on prem.

So not clear still- step 1 is what exactly- connect to mysql data source and then in power query transform and save the file (mysql file in BI desktop)-right?

Step 2 then is from a new power bi desktop obtain the detaverse data source -transform in power query and save into desktop as dataverse.

you are first saying do 2 separate power query for each source but then you are saying connect id data model- so how are you adding the two separate queries into the same power bi without adding data source to the dataverse or the mysql BI desktop?