R Regex integration with an on-premise data gateway

[Varinx]

Hello,

I have made a data Quality PowerBI report that connects to a Salesforce CRM source.

In this report, I use an R script directly in PowerQuery to perform a Regex on 2 columns to check if they are valid.

However, when I want to publish this report online using an on-premise Gateway, I have problems because R is only supported in personal mode.

I looked to try and work my around this, but DAX doesn't offer a proper Regex alternative.

Do you have any ideas on how I can solve this problem?

Regards

[Varinx]

Hello,

I am getting my data from SalesForce CRM, so I have to connect the CRM Data to SQL server and then use the R service module?

That means that I need to run my own "SQL Server" server?

Anyways, thanks for the response, but I'd be keen if someone had a better solution

[Anonymous]

Hi @Varinx ,

Yes, R scripts can only be used in personal gateways. If you want to use R scripts in Power BI Service, you need to use a personal gateway.

One possible workaround is that you first transform the data on SQL Server using R Services module, then loads the data from there.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.