Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Building an excel form to be used in Power BI

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I have a form which is filled by the users in Excel.   Screenshot

 

Capture.JPG

 

The user starts with the First quetion - Number of Years . User enters any value between 1-5.

Then the second question is made visible - COL Base. 

Depending on the answer Yes or No, The column  Code and Price is populated from a look sup sheet is excel.

 

The next Question Cos Line or Factory should be populated, if the answer toi COL Base is No.

This question will have answwer Yes or No and based on the answer the columns Code and Price is populated.

 

I want to use Flows to do this and the data to be shown as a table in Power BI.

 

Is this achievable ? Is this to be done using Forms, Flows and Power BI ?

 

Any help will be highly appreciated.

 

Best Regards

 

Srini

  • yashag2255 Profile Picture
    yashag2255 24,442 on at
    Re: Building an excel form to be used in Power BI

    Hey @cheenusing 

     

    Yes, you can create an MS Form as per the requirements and then using flow, populate that to an excel sheet. Note that if the excle sheet is online and the PowerBI report is based on that you can simply add the row to the excel file and then add an action to refresh the PowerBI report in flow. 

     

    If you want to completely bypass the excel part, you can add an action to add a row in the PowerBI dataset and then immediately refresh it. --> the flow will be triggered when somebody responds to the form, then get response details, add the row and refresh the data set. 

    fdd.PNG

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Building an excel form to be used in Power BI

    Hi @cheenusing,

     

    It is possible to create the such Microsoft Form by using branching rule, there is the document that how to use it:

    https://docs.microsoft.com/en-us/forms-pro/create-branching-rule 

    And you can create a Flow with a trigger When a new responded is submit to get the Response, then put into a excel table.

    But There is no action could import excel file into Power BI, so you need to import it using PowerBi, not Flow.

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics