Forum Discussion
Collect Data From Multiple Users and Visualize in Power Bi
Yeah, without an Office 365 license (E3 or higher, or possibly Business Premium), you'd need separate Power Apps licenses, and if you don't have an Office 365 tenant, then there is no SharePoint lists to use, with or without Power Apps, and no Forms either.
Today i've discovered that i have a Office 365 license E3 so i can use both PowerApp and Form 🤣
Regarding your first message:
1)Microsoft Forms (it uses an Excel file as the backend but the user never touches it directly, and it is a nice Excel table)
I created a Form, but i don't understand how to connect that in real time with Power BI.
Is there a direct connector or i have to use Power Automate?
2) SharePoint Lists - very structured and hard for users to mess up, especially if you put a Power Apps front end on it to lock down what they can enter. For example, you can have a column that is a percent, but SharePoint Lists will not easily let you limit it to a certian format. For example, what is 1.25? 1.25% or 125%? Power Apps can help you limit it.
I have some PowerApp skills, do you have any tutorial about this process? I don't know anything about sharing an app in SharePoint!
Again.. THANK YOU VERY MUCH!
For Forms, you just connect to the Excel file. You can find the Excel file by going to your form you designed, select the "Responses" tab, then Open In Excel. It will be in SharePoint whereever you created it. But opening that Excel file on your desktop, then select File, Info, Open File Location will take you there. Standard Excel connection after that.
Regarding PowerApps and SharePoint Lists, Shane Young has the best videos on this. Check them out on YouTube.