Unanswered

Replicating transformations created in PowerBI in the PowerApps universe Dataverse

(0) Share

Report

Posted on by Community Power Pla...

Apologies, I duplicated this question. My bad
https://powerusers.microsoft.com/t5/Building-Power-Apps/Data-transform-and-merge-using-power-apps/m-p/1660518

Hi all,

I am trying to automate a Power BI process whereby a number of csv tables are ingested, transformed and then exported to a csv (using R) at the final query stage. This requires a refresh action via the ribbon. There is now a need to automate this process.

Have tried Power BI Service, with a power automate trigger however I can’t get the Service to write to a csv using R, not sure this is possible.

I was wondering if this might be a suitable candidate task for Dataverse?

Very new to DV but have managed to import the CSV’s via dataflows, however can’t work out how to join these to transform into a single final table or dataset. I think I am looking for something like Table.Join(SourceCSV1,{“Key1”,”Key2”},SourceCSV2,{“Key1”,”Key2”},JoinKind.Inner) or similar

Is it possible to merge tables, then transform within Dataverse, using dataflows and M code?
Many thanks,
Pete

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hi @PeterP, You can run R or Python using the PRA. Here is a starting point for how you do that.
https://www.youtube.com/watch?v=NxJ2Zch7M2o&ab_channel=MicrosoftMechanics

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @PeterP ,

This does not look like a good candidate for Dataverse at this point. I would suggest looking at Azure Data Factory as this is truly ETL work and ADF is good at this. Also see some articles / discussion on calling R from ADF as well (https://dataninjago.com/2018/07/20/execute-r-scripts-from-azure-data-factory-v2-through-azure-batch-service/)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you all for your comments, will investigate ADF and will let you know how I get on.
To elaborate, I am hoping to jettison the R writing to CSV bit by connecting the reporting layer directly to the transformed data in the MS environment, using Power Pivot within excel, so the R element will drop away. The original data reporting layer was built many years ago in power BI when most of the users had power pivot as an add in, but no access to Power Query, hence the need to produce the staging csv extract. Thanks again for your help.

Was this reply helpful? Yes No