Forum Discussion

haroldd's avatar
haroldd
New Member
6 years ago

How do I protect the IP in my Power BI solution?

I've developed a Power BI dashboard (.PBIX) that runs SQL against an on-prem SQL server to light up the visuals. I want to distribute the PBIX file to customers who license the solution but I don't w...
Need Help
haroldd's avatar
haroldd
New Member
6 years ago

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.

 

nsc's avatar
nsc
Icon for Advocate II rankAdvocate II
6 years ago

Got it. The best way as I see it would be to test if Template Apps (https://docs.microsoft.com/en-us/power-bi/service-template-apps-overview) support your scenario, but you may already have tried that (dont know if gateways are supported yet).

 

You could also look into Custom Data Connectors, but that will only allow you to control the Power Query logic (which would/could cover your SQL) but not the DAX which would still need to be shared.