How to get already created MS Forms into PBI automated

Question

This link was working fine but recently has created an error.

I have tried using excel app desktop file path link and is working fine but not automatically updating

Answer 1

Hi Nikita Hirst:

You are welcome to post in our forum.

From your description, we understand that you seem to be having issues with Power BI, I found a similar post that might help you solve your problem, You can refer to the steps in the documentation to see if it helps you：How to Connect MS Forms to Power BI (iterationinsights.com)

If my understanding is wrong, could you please share your specific steps so that we can understand your situation in more detail.

Best regards,

Tin

Answer 2

Yes this works for newly created forms. But for forms that are already up and running with data. How can I get this into PBI and automated?

Answer 3

Hi Nikita Hirst：

Thank you for your reply.

According to my test, for data that has been submitted, you need to import data into the worksheet, link to PBI through Excel, depending on your original post, it seems to have completed this step. Then for the subsequent data, you will need to create a workflow to import data.

This will refer to the fourth step in this document to see if you can help you.：Import Microsoft Forms Responses into Power BI (iterationinsights.com)

Since your problem involves PBI and Power Automate, these two applications are not within our support, so I can provide a limited helpful suggestion.If you have further problems, we recommend that you can post in this forum： Microsoft Power Automate Community - Power Platform Community for, there will be more experts here to help answer such questions.

Thank you for your understanding.

If I have any misunderstands, welcome to contact me. And I will further investigate it.

Best Regards,

Tin