Get data from different sources

Hi mcody 

You can connect to SQL Server in Power BI Desktop using SQL authentication credentials. Choose Database option in the following screenshot, then enter your username and password to connect to SQL Server.

You can connect to SQL1 in Sever2 by sa account in SQL1.

Or you can Build two reports by SQL1 and SQL2, then publish two reports to Power BI Service.

Configure gateway for SQL1 and SQL2. 

Then get power bi dataset in desktop and change data model to local model(Direct Query).

Finally you can get two dataset by directquery in Power BI Service.

However, it is not supported to do some transform on data soucre from power bi dataset in Power Query Editor.

It is not supported to show queries in Power Query Editor.

For reference: DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.