17 Sep 2019

Using Power BI with Forge

Autodesk does not currently provide any data connectors for Power BI which would enable you to get data into Power BI directly from a given Forge service. Without that, moving data from Forge to Power BI has 3 steps:

1) Get data out of Forge
2) Move data into a database or file format that Power BI supports
3) Connect Power BI to the data source

Forge to Power BI

The only Forge related part in the above process is getting data out of Forge, and that will vary based on what data you need.
You can get object properties from a model through the Viewer or through the Model Derivative API, there are API's to get issues and other data out of BIM 360, etc
So you just have to look at the specific Forge API's to get the data you need. 

Here is a sample following this approach: https://forge.autodesk.com/blog/clash-analysis-powerbi

You may even decide to develop a Power BI data connector for the given Forge service ?

Also, a colleague has created a Power BI Template to help you get data out of BIM 360. Have a look at this article talking about it:
https://forge.autodesk.com/blog/sam-nseir-integrate-bim-360-data-powerbi-using-r 

 

Related Article

Posted By

Adam Nagy

Follow @AdamTheNagy Adam Nagy joined Autodesk back in 2005 and has been providing programming support, consulting, training and evangelism to external developers. He started his career in Budapest, then worked in Prague for 3 years and now lives in South England, UK. At the moment focusing on Inventor and Fusion 360, plus cloud and mobile related technologies. Adam has a degree in Software Engineering and has...