Building Access Template and The “Holidays Error”

The Building Access app template for Teams is one of the most successful app templates we created. It is being used by hundreds of customers worldwide to control how employees get authorizations to work onsite during the COVID-19 crisis.

It is a Microsoft Power Platform based app that supports the administration of building occupancy thresholds and social distancing norms by enabling facilities directors to manage, track, and report employee on-site presence.

The app was created using Microsoft Power Apps, and Power Automate, and it is deeply integrated to Microsoft Teams, allowing organizations to determine building readiness, establish eligibility criteria for on-site access, and gather insights for future planning.

We also had over time multiple community forks, like the versions 1.15 and 1.16 that were created from the original version and implement features like workspace selection, floor maps, health attestation questions per building and a lot more.

Building Access Version 2.0, the official Microsoft version, also implements reservation for periods of the day and a new interface that respects fully the Teams best practices on reactive applications.

It doesn’t matter what version you have deployed, the Power BI report file uses a public webservice to create a public holiday table. Unfortunately that public service is not working anymore, and multiple customers are complaining the reports started to throw an error during the update process.

I spent some time earlier today to fix those errors on the reports that can be used for versions 1.15/1.16 and 2.0. You can download the new PBIX file using the links below:

Versions 1.15 or 1.16 (or any other version based originally on v1.0):

Version 2.0:

Hope this helps!


Disclaimer – The information contained in this blog post doesn’t represent the official Microsoft guidance or best practices. It is just the view of the author on current alternatives, implementations and workarounds for common issues and/or business needs. Please refer to official Microsoft documentation and evaluate carefully any steps, code or procedures documented herein. The author doesn’t offer any warranty. Use this information at your own risk.

3 thoughts on “Building Access Template and The “Holidays Error”

Add yours

  1. Thanks for this, this got rid of the error for this. But i am also seeing another error :

    Expression.Error: The column ‘ID’ of the table wasn’t found.

    on the following querys :


    I deployed it last week, and then again but its still showing this error.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Powered by

Up ↑

%d bloggers like this: