Forum Discussion
Resolver IIIHow to get this one???
Hi,
I have Restaurants in different locations.
I Developed dashboard based on restaurants here showing all restaurants data and my dashboard linked to the web.web users choose one location according to location
Web users choose one location according to location my dashboard also showing that location restaurant data only not for all restaurants.
Is there any process to controlling data and every day new restaurants will add my database.
It is very important for my project.
Please solve this problem and let me know if anything required.
Thanks,
Gopi
3 Replies
v-caliao-msftMicrosoft Employee
Is there any process to controlling data and every day new restaurants will add my database
Do you mean you need to the up to date data for your dashboard? In your scenario, which data source did you connect? If you connect to data source like with an Excel workbook or Power BI Desktop file that connects to an external online or on-premises data source, you’ll need to refresh manually or setup a refresh schedule so Power BI can refresh the data in your reports and dashboards for you.
Please refer to the link below to see the details.
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/Regards,
Charlie Liao
gopichillaThank you for ur response.
Here I am in the US in this case only showing the US Location Restaurants, not for all location Restaurants.
- v-caliao-msft
You need to have a location column for your restaurants. And then create different role for different locations. For the users from different location, add them to correspoding role, and then they can only see the data for tha location.
Regards,
Charlie Liao