Hi, @butterscotch
You can link to Microsoft List through Power BI or Power App. Migrating your data from Excel files to Microsoft List and PowerApps provides a more user-friendly and flexible platform. Here are some steps and suggestions:
1.Microsoft List: Microsoft List is a powerful tool for creating and managing structured data lists. There you can define columns, add data, and share it with others.
You can import data from Excel into Microsoft List. Create a new list in SharePoint and then use the "From Table" option to import the Excel data. In Microsoft List, you can define custom views, filter, sort, and set permissions so users can only access the data they need.
2. Connect PowerApps to Microsoft List: In PowerApps, you can connect to Microsoft List using the SharePoint connector. Create a new PowerApp and select Connect to your Microsoft List. You can choose to use an existing list view or create a custom form. In PowerApp, you can add fields, create interactive interfaces, and save data back to Microsoft Lists.
The link below is a detailed tutorial on configuring Microsoft List to link to Power BI:
How to Use Microsoft Lists With Power BI: https://www.techrepublic.com/article/how-to-use-microsoft-lists-in-power-bi/
Solved: Connect PowerApps to Microsoft List - Power Platform Community
https://learn.microsoft.com/en-us/power-bi/create-reports/service-quick-create-sharepoint-list
How to integrate Power BI visuals into PowerApps - Power Platform Community (microsoft.com)
How to Get Your Question Answered Quickly
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
