cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ConorRS Frequent Visitor
Frequent Visitor

Work around to write data onto PowerBI

Good Afternoon,

 

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?

 

Many thanks,

 

Conor

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Work around to write data onto PowerBI

Hi ConorRS, 

 

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.

 

Regards,

Jimmy Tao

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Work around to write data onto PowerBI

Hi ConorRS, 

 

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.

 

Regards,

Jimmy Tao

View solution in original post

ConorRS Frequent Visitor
Frequent Visitor

Re: Work around to write data onto PowerBI

Hi Jimmy,

 

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.

 

Thanks,

 

Conor

Community Support Team
Community Support Team

Re: Work around to write data onto PowerBI

Hi ConorRS,

 

Does my answer make sense? If it is, could you please help mark the answer? Your contribution will be greatly appreciated.

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 727 guests
Please welcome our newest community members: