You're reading from Managing and Visualizing Your BIM Data Understand the fundamentals of computer science for data visualization using Autodesk Dynamo, Revit, and Microsoft Power BI

Product type Paperback

Published in Nov 2021

Publisher Packt

ISBN-13 9781801073981

Length 436 pages

Edition 1st Edition

Tools

AutoCAD

Concepts

Computer Aided Design

Authors (5):

Dounia Touil

Gavin Crump

Ernesto Pellegrino

Manuel André Bottiglieri

Luisa Cypriano Pieper

+1 more

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Overview of Digitalization and BIM Data

2. Chapter 1: Introducing Units of Digital Information FREE CHAPTER

3. Chapter 2: Understanding Data Centers

4. Chapter 3: Warming Up Your Data Visualization Engines

5. Section 2: Examples and Case Studies from Experts around the World

6. Chapter 4: Building a Data Bridge between BIM Models and Web-Based Dashboards

7. Chapter 5: Getting Started with Autodesk Dynamo and Data Gathering

8. Chapter 6: Importing Revit Plans in Power BI Using Shape Files

9. Chapter 7: Creating a Revit Model-Check Dashboard Using Dynamo and Power BI

10. Section 3: Deep Dive into Autodesk Dynamo

11. Chapter 8: Deep Dive into Dynamo Data Types

12. Chapter 9: Using Dynamo to Place Family Instances

13. Chapter 10: Gathering a Revit Model's Data from Multiple Models at Once

14. Chapter 11: Visualizing Data from Multiple Models in Power BI

15. Chapter 12: Having Fun with Power BI

16. Other Books You May Enjoy

Packt is searching for authors like you

Understanding how to publish the dataset

This section will teach us to link the Google spreadsheet to Power BI, which is already mirrored to the Google Form responses. We are talking about a type of connection that will automatically update our charts. How can we do that? Let's see:

Open the Google spreadsheet created previously. If you can't find it, go to your Google Drive using this URL, https://drive.google.com/, and then navigate your drive's folders until you find the Google form or spreadsheet.
If you locate the Google Form file, open the Responses page and click on the green icon in the top-right corner of the main panel. We did the same before. If you have issues, check Figure 12.10.
Once you have the spreadsheet open, click on Publish to the web from the File menu, as shown in the following screenshot:
Figure 12.14 – Publish to the web feature
Now a new window will pop up. Don't click on the Publish button immediately as the...