Using Flow and Power BI to Export to pdf

[markpa]

The users want a process that produces a radar chart based on a questionnaire. When survey is completed they should be emailed their answers and have radar chart attached.

As a radar chart need the data as a category and score I found it easier to build a flow that updates rows in spreadsheet instead of having a dataset of all the variables and scores.

I have been able to create form & develop a flow that updates the rows in spreadsheet.
My Power BI report displays the information correctly after the datasource has been refreshed.

What I can't seem to do is get the flow to export the report as a pdf, so that the pdf can be attached to the email.
I have read previous answers which show how to attach a file (which I can do) or say this can be done manually but the whole point of a flow is to automate it.

Earlier answers noted Export to PDF only in Desktop but it is available Online now.

[v-eachen-msft]

Hi @markpa ,

I am afraid that you need to export Power BI reports to PDF manually. 

You could come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

[markpa]

Thanks @KBO & @v-eachen-msft .

That seems to confirm what i had found.

I'd much prefer to use the PowerBI radar chart but it looks like the fallback is to use the spreadsheet that is holding the data and use the Excel radar chart.

For some reason it puts in .5 values (1.5, 2.5 ,...) even though my scores are integers, and it doesn't show the arms, but at least I have a workaround if the users are amenable.

[KBO]

Hi @markpa,

I only found this https://www.powerbitiles.com/?app=PBIRobots

a direct extract with Power Automate is currently not supported but I heard it is on the roadmap for this year ;).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!