I have created a financial dashboard on PowerBI in which project managers can view their financial KPIs. We have a seperate online excel sheet in which they fill in comments based on similar KPIs, the issue with this is that there are many project managers using it at the same time and with excel online if someone filters it, it filters it for everyone else and this is causing many issues.
Is there any way using another app, these PMs can fill in something which maybe updates the original excel data source which updates the PowerBI dashboard, effectively writing data onto PowerBI?
Based on your senario, your pms will work on one data source(excel) and you need a feature which can reflect the real-time data after every modifications on the data source, right? You can create a new app workspace or app workspace and add these pms as the members, then create a streaming dataset which can let data in dashboard be real-time.
The issue is that I want to remove the PM's use of excel completely, as when they update the live excel sheet they use filters and sorts and when there are several PM's doing that it keeps changing the screen for everyone else meaning they are unable to type in their comments.
So I need a way of inputting data into PowerBI where filters and sorts are personal and don't affect other users.