1. Open power bi and click on sql server

  2. Add jxe-db02 under server and your database name

  3. You can paste your sql query under sql statement and then hit ok 





  1. Click on load to start with analysis or click on transform to further make changes in your data