The need for external languages with Power BI

If we have introduced the possibility of using SQL Server external languages to apply advanced analytics techniques to data, it is because sometimes it may be necessary to do so instead of using the standard Python and R integration feature in Power BI. The first case is related to the policies of the company that needs to use this feature. Let’s see what that is.

Architectural and security policy constraints

So far, we have taken for granted a basic requirement for using Python and R in Power BI that turns out to be a bit of a stretch in the context of enterprise architecture: we are talking about using the Power BI on-premises data gateway in personal mode. As you may already know, Power BI limits each user to running only one data gateway in personal mode. This means that if a user installs another data gateway in personal mode, even on a different computer, the latest installation will replace any previous installation...