Can we convert R script to M code (Power Query)

Manohar Kondragunta 0

As we are having few scripts in R which we are consuming in another scope, as per the new scope that needs be migrated to M (Power Query). If so, are there any best practices to migrate existing scripts to M code.

Do we have any tools that can be used to convert these scripts to M code.

AnnuKumari-MSFT 31,151 Reputation points Microsoft Employee

2023-01-31T14:35:30.55+00:00
Hi Manohar Kondragunta ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you want to migrate your code in power query from R script to M code.

Unfortunately, as of now , there is no direct tool to convert R scripts to M (Power Query) code. However, here are some steps that could be followed as best practices for migrating R scripts to M code:

Understand the functionality of the R script and map it to equivalent functions in M.

Break down the R script into smaller, reusable parts and translate each part into M.

Test the M code for correctness and performance compared to the original R script.

Refactor the M code to optimize its performance and readability.

Document the M code to make it easier for others to understand and maintain it.

References:

Use R in Power Query Editor

Power Query M formula language
AnnuKumari-MSFT 31,151 Reputation points Microsoft Employee

2023-02-10T04:27:15.64+00:00

Hi Manohar Kondragunta ,

Just checking in to see if the above suggestion was helpful?