That is not what I said.
I said that I DID/DO use an Azure SQL VM with SSRS that costs (will/expect) less then 60 PowerBI Premium Per User Licence.
- Simpler
- Cheaper
- No Learning curve to learn how to convert rdl to PowerBI Premium Paginated Report
- Immediate deployement
- 15 years of SSRS knowledge
I just did it yesterday.
I am a consultant and have my development environement (VS2019) on my own computer outside of Azure so I need to be able to deploy reports from my own computer to the Customer's Azure SSRS portal
So I needed to open ports to allow me to deploy FROM MY COMPUTER OUTSIDE OF AZURE.
So I ...
1) Open Azure all ports from my personel public IP (from my ISP) to allow my conputer to access the VM (could have opened only RDP and HTTP)
2) In the Azure VM, In WIidows Firewall settings, opened port 80 for public access (step 1 only allows me to publicly connect)
So now I can deploy reports in VS2019 on my computer (not in Azure) to the Azure SSRS portal.