Need help newbie

Hi All,

I want to create a dashboard using power bi and we recently purchased Power BI pro.

1) I am creating a report using query (selected the optiondirect query) using the desktop since i read we cannot create reports using Power BI service.

2) Once in desktop when i clicked on getdata and then used advanced options to paste my query , i get the message as because of my transformations in the query it cannot be published. I constantly have the Apply changes on top of my reports. So as of now i am saving the reports to my local drive and then adding them manually in Power BI.

3) I created a dashboard and added the two reports. But they are on different pages , is there a way i can show them side by side.

please need help.

Thanks