Forum Discussion
Is it possible to populate a report based on one data row and export it?
Hello,
I am new to PowerBI and hopefully this is the correct Forum spot to post this.
I am trying to build a report that can add graphs to the latest submission from a Microsoft Form and then export it as a PDF and email it out. I don't want the report to show all data, only the individual's submission. Is this something that can be done if I put the data somewhere like dataverse or sharepoint since Forms doesn't seem to be able to get data to PowerBI?
Hi guywhoneedshelp ,
Yes, this is achievable.
Instead of writing all steps, here are a few very good video tutorials on how to do it:
https://www.youtube.com/watch?v=Q7W1BX-gvaA
https://www.youtube.com/watch?v=XBFVDedwLiY
https://www.youtube.com/watch?v=ie7HB6yv8qM
Cheers,
NemanjaHi guywhoneedshelp ,
Thank you for reaching out to the Microsoft fabric community forum.
You're correct, and as nandic has shared, this scenario is achievable with Power BI and Power Automate.
Since Microsoft Forms does not connect directly to Power BI, the first step is to use Power Automate to store each form response in a supported data source such as SharePoint, Excel (in OneDrive), or Dataverse. Once the data is stored, you can connect it to Power BI and build a report that visualizes only the latest submission this can be done by applying a "Top 1" filter on the submission timestamp or using DAX to flag and filter the latest record.
After publishing the report to the Power BI service, you can again use Power Automate to export the filtered report to PDF and send it via email.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
5 Replies
- nandic
Resident Rockstar
Hi guywhoneedshelp ,
Yes, this is achievable.
Instead of writing all steps, here are a few very good video tutorials on how to do it:
https://www.youtube.com/watch?v=Q7W1BX-gvaA
https://www.youtube.com/watch?v=XBFVDedwLiY
https://www.youtube.com/watch?v=ie7HB6yv8qM
Cheers,
Nemanja Hi guywhoneedshelp ,
Thank you for reaching out to the Microsoft fabric community forum.
You're correct, and as nandic has shared, this scenario is achievable with Power BI and Power Automate.
Since Microsoft Forms does not connect directly to Power BI, the first step is to use Power Automate to store each form response in a supported data source such as SharePoint, Excel (in OneDrive), or Dataverse. Once the data is stored, you can connect it to Power BI and build a report that visualizes only the latest submission this can be done by applying a "Top 1" filter on the submission timestamp or using DAX to flag and filter the latest record.
After publishing the report to the Power BI service, you can again use Power Automate to export the filtered report to PDF and send it via email.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
Hi, guywhoneedshelp ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi, @guywhoneedshelp ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi guywhoneedshelp ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.