In web version of Power BI, we are not able to create new Report by connecting to on-premises SQL Server database (also it does not have query editor),So we have a requirement of displaying Power BI desktop on asp.net page of a web application.
@raghu There are two ways you can get Power BI info into a web page.
The first is to create your solution in a desktop file in order to edit the query, etc. Then publish to the Service. From the Service you can go to the report and "Publish to Web" under "File" (this is in preview though, and be aware that you are making your data public)
The second option is the new "Power BI Embedded" feature that was just announced at the /BUILD conference. I'm not 100% familiar with this, but it appears to start by using the desktop and utilizing that desktop file in your application.
@Eno Thanks for your suggestion, i guess my question was not clear. My requirement is to provide user to design reports in Power BI from our web application. So i need to invoke Power BI Desktop inside asp.net page. If this is not possible then is there any other option to display designer within an asp.net form with all features like Advanced Query editor available.