CODEWITHSUNDEEP
rpowerbipower-bi-report-server
Brisbane Pom
Brisbane Pom

Reputation: 611

Is there a way to run an R script in Power BI Server when using an Enterprise Gateway?

I have included an R Script in a PowerQuery in Power BI to transform data. This works in Power BI Desktop, however when I push to Power BI Server I receive the following error message when looking at the (Enterprise) gateway:

Extension{"extensionDataSourceKind":"R","extensionDataSourcePath":"R"} Cannot be added to gateway

Doing some Googling / looking at the Power BI Community pages suggests that the Enterprise Gateway does not support R Scripts - something to do with it being too memory intensive for Microsoft to want to support running R on the cloud server. But I can find very little concrete documentation on this (more opinion):

https://www.sqlgene.com/2018/09/25/power-bi-error-r-cannot-be-added-to-gateway/

https://community.powerbi.com/t5/Power-Query/Refresh-R-Scripts-with-Personal-Gateway/m-p/445494#M17917

Has anyone found a solution to this or developed any suitable workarounds? e.g. can the Personal Gateway be used as an alternative or does the Enterprise Gateway support the running of Python Scripts?

I'm keen to hear of any strategies that people have found to running R scripts on the Power BI Service.

Upvotes: 4

Views: 5385

Answers (1)

Jon
Jon

Reputation: 4967

You cannot use the enterprise gateway for R Scripts in Power Query. You can use the personal gateway, it will work on that, that is the current work around.

One client I have transforms the data on SQL Server using R Services module, then loads the data from there, that is one possible work around.

Upvotes: 5

Related Questions