I created a Power BI report and tried to save as SQL Server Reporting Services. But when I enter the report server address in that field it says "This URL is not a valid report server address". But I can see the URL in the Reporting Services Configuration Manager and when I type the URL in the browser I am able to see the portal. The URL looks like this:
1. What am I doing wrong?
If I understand the concept of Power BI reports in SQL Server Reporting Services, It can be used on-premises right?
2. So, can I publish the Power BI report to my SQL Server Reporting Services and include the report in an iframe in my ASP.NET MVC application that I have hosted in my IIS server?. Basically can I do all of this without having an online Power BI subscription? If yes, how? I can't find any documentation on this. If no why? What's the purpose of "BI reports in SQL Server Reporting Services".
3. Is there any other way to display Power BI reports (on-premises SQL Server datasource) in my ASP.NET Application hosted on my IIS Server without publishing to the internet?
My Reporting Server Version When I go to : http://myserver/ReportServer
Microsoft SQL Server Reporting Services Version 13.0.4001.0