Forum Discussion

nagaraj007's avatar
nagaraj007
Icon for Post Patron rankPost Patron
6 years ago

Conference Room Availability

Hello All,   Right now in our office, we are calling to the Reception team to check which conference rooms are free and based on that we ask them to block the rooms. This is taking lot of time when...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi nagaraj007 ,

 

If i understand you correctly, you can ask Reception team to create an excel contains Roomnames and Roomstatus then create a table visual and publish the report to Power BI Service and share the report with you. Use Gateway to connect on-premised excel file with report on cloud service. Once a conference room is blocked, change the status in Excel to "block" and refresh dataset in Power BI Service then the report which is shared with you will refresh too(you can refresh report manually to make sure the report is latestet). And once a conference room is free, change the status in Excel to "block" and refresh dataset in Power BI Service.

 

Hopefully works for you. If i misunderstand your meaning, please let me know.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.