Entering a form in Power BI Report

[anmolmalviya05]

Hi Everyone, I'm trying to create a report in power BI.

I want to include a contact us page, in which user can enter their details (Name,contact no. mail, job title etc) and we will be able to access that details,

Is this possible in Power BI? can we include microsoft form or something like that so that this can be successful.

[grazitti_sapna]

Hi @anmolmalviya05 

Power BI does not natively support forms for user input directly within the report. However, you can integrate a Microsoft Form to collect user details and access that information.
Here’s how you can do it:

• Create a Microsoft Form:
  Go to Microsoft Forms and create a new form for collecting details such as Name, Contact Number, Email, and Job Title.
  Customize it as needed and copy the sharing link.
• Embed the Form in Power BI: there are Multiple Ways to Embed a Form Link
  1. Using Buttons or Shapes:
     Description: You can create a button or shape that links to a web URL or another report page.
     How to Implement:
     Insert a button or shape from the Insert tab.
     Enable the Action option and set the Type to Web URL, then enter the link.
  2. Using Image Links
     Description: You can link images to web URLs.
     How to Implement:
     Insert an image using the Insert tab.
     Use a shape or button overlay with an action to link the image to a URL.
  3. Adding Hyperlinks in Text Boxes
     Description: You can create a text box with embedded hyperlinks.
     How to Implement:
     Insert a text box and type the desired text.
     Highlight the text and use the Insert link option to add a hyperlink.
  4. Web URL in Table or Matrix Visuals
     Description: You can create a table or matrix that includes a column for web URLs.
     How to Implement:
     Create a data model with a column of URLs and another with image URLs (if applicable).
     Use the Data Category feature to set the URL column as a Web URL type.
  5. Embedded Web Content
     Description: You can embed external web pages or applications using the Web content visual.
     How to Implement:
     Go to the Insert tab and select Web content.
     Paste the URL of the webpage you want to display.
• Access the Form Data:
  Responses from the form will be stored in the Microsoft Forms interface. You can access these responses directly or connect them to Power BI via Excel or Microsoft Power Automate.
  If you want to visualize the collected data in Power BI, use Power Automate to push form responses to a data source like SharePoint or an Excel file stored in OneDrive/SharePoint, which can then be connected to your Power BI report.

This setup allows you to enter their details in the Power BI report via the embedded form, and you can access and visualize this information as needed.

If I have resolved your question, please consider marking my post as a solution🎉. Thank you!

[Kedar_Pande]

@anmolmalviya05 ,

You can use Power Apps to do this.

Link for your reference- https://youtu.be/uPHwjPRnRwE?si=dAuIp0KqyPicO1JQ