My Client does not want to store any data in the cloud, therefore normally Power BI report server would be the best option.
However, the company does not have the sql enterprise edition with software assurance package and does not want to require PBI premium per capacity license as its to expensive and overkill for their purpose.
Is power BI desktop and Power BI service with on premise data gateway the solution?
If so, as they want to avoid caching as well, do I assume that all table connections should be direct query?
if yes, Could you provide me additional info and sources on this?
Thanks in advance!