Creating Word document from Power BI report

[Anonymous]

Hi!

I'm currently using Power BI to create graphics and visualisations from data. I found out recently that "R" is also integrated in Power BI and I got this idea to use it to create word document based on the visualisations in my Power BI report. I know It's possible to create a word document from R but I would like to know if I can do the same from the R installed in Power BI and more importantly have all the visualisations I want in this document?

Thanks in advance.

best regards 

[Anonymous]

Hi,

I would use Power Automate to reference that data exported via R and then reference this data in the Word document using Content Control fields. For example, if you can output the data as CSV, you could pick this up using Power Automate and either reference it directly (not sure 100% how as I have only output CSV files and not used them for input). Or, you could turn the CSV files into structured data as an Excel file as part of the Power Automation process. These header fields could then be referenced in your Word template using Content Controls. Power Automate would be able to map those fields from Excel to Word, and there you would have your Word document populated.  

[Anonymous · Accepted solution]

HI @Anonymous,

Nope, I don't think it is possible.

When you execute r script in power query side, you can use it to export query table records as external files.

If you are working with r visual, you can use r script to export visuals records. It is impossible to export others visualizations.

Regards,

Xiaoxin Sheng