How do I facilitate access to an Azure based SQL View for non-SQL users on Prem?
You can use Power BI service and Power BI Mobile Apps to share reports with others as explained here. Take a look here at the Publish to Web feature in Power BI.

Here you can see how easy is to create a report from SQL Azure data on Power BI.

Hope this helps.