Forum Discussion
How do I protect the IP in my Power BI solution?
Advocate IIThere is no way you can distribute a PBIX file and not give them the DAX. With you SQL being onpremise you would also need to open up your server for internet access which is not recommended.
If you have your data on-prem you'll need a gateway under any circumstance for sharing in the service. Is it not possible to migrate to Azure SQL? Then you could use Template Apps which allow you to hide the DAX as well as the source.
Otherwise if all the customers can be in your tenant (either invited or with separate accounts) simple create an app and give them access that way. You can assign Power BI Pro licenses to external users for use in your tenant if need be.
Thank you for your reply. Perhaps I did not explain myself properly. The data that is consumed by the dashbaords will be from a SQL Server in the customers environment - not from our SQL server. The customer will use the PBIX file (or PBIT file), then set the data source to their own local SQL instance. The challenge is we have no way of preventing the users from viewing the SQL.