Upgrading IFC Power BI Reports to VIM SQL v5.6.0.c

This guide covers how to upgrade a customized IFC Power BI report for compatibility with VIM SQL v5.6.0.c.

Read this before you start

The steps below assume your custom report is based on the template:

BimAudit-IFC-SQL5.6.0-U5.1.0-DM0.14.0.pbix

Need help?

If you need help upgrading, please give us a shout!

Initial Setup

1. Create a backup of your customized Power BI report.

2. If you have not already done so, install VIM Enterprise v1.2.141.17 or later.

3. Open the new IFC template which targets "VIM SQL v5.6.0.c" in one instance of Power BI Desktop:

BimAudit-IFC-SQL5.6.0.c-U5.1.0-DM0.15.0.pbix

4. Run your VIM Enterprise IFC project to update the project's database to VIM SQL v5.6.0.c.

5. Open a copy of your customized IFC report in another instance of Power BI Desktop.

6. Ensure your report's data source is set to the newly updated database via "Transform Data" > "Data source settings"

7. Press "Apply changes" to load the data from your newly updated database.

Transform Data Updates

8. Go to "Transform Data"

9. For each table below, copy the "Advanced Editor" table definition from the new IFC template into your report.

   
   
   when you are copying...

   • Replace the text value "localhost\SQLExpress" with your database server name.

   • Replace the text value "vim-empty-v5.6.0.c" with your database name.

   Group Folder	Table Name		Notes
   Core	Element	🔹	Source updated to "vw_Element_v4"
   Core	Element-Parameter	🔹	Source updated to "vw_Parameter_v3"
   Core	ElementType-Parameter	🔹	Source updated to "vw_FamilyTypeParameter_v3"

10. Save your changes.

11. Press "Close & Apply"

Report Pages

12. Click on each report page to ensure all data connections are valid.

13. Save your changes and validate that everything is working well.

Still stumped?

If things didn't go to plan, please reach out!