Assemble Products Forum
Welcome to Autodesk’s Assemble Systems Forums. Share your knowledge, ask questions, and explore popular Assemble Systems topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Assemble Power BI Connector-Multiple Projects

5 REPLIES 5
SOLVED
Reply
Message 1 of 6
kevinQ3TQJ
545 Views, 5 Replies

Assemble Power BI Connector-Multiple Projects

Using the Power BI Connector to Assemble we want to pull data from all projects. Is there a way to do this and have it refresh in the PowerBI cloud service?

5 REPLIES 5
Message 2 of 6
mprobertsMHZTJ
in reply to: kevinQ3TQJ

@kevinQ3TQJ  you could do it, but it depends on what you are trying to pull from every project. 

 

If you are wanting all data from all models in every project, you might set your computer on fire. If you are only wanting select things from select views in each project, you can do that by importing the first set of data, duplicating it for each project, then appending all of the data together in a single table. After you do that, you "disable load" on the individual tables and you will be left with 1 single table that you can use which contains data from as many projects as you want.

Message 3 of 6

Hi @mprobertsMHZTJ 

 I am looking at the same issue, but I am not sure whether I understand the possibilities well.

I would like to insert various versions of the same assemble Project fast, in order to update all changes in the process of quality control.

I do not know what is the best Connector, I acces Assemble From Power BI, Get Data, "Assemble Views", and acces the URL.

I find two options.

"Model selection " looks best, ,I see both the version and the model name  as a parameter.

But I would have to select all the parameter manually, or can I store this somewhere?

"View Select" gives me all the parameters assigned to the columns in this view, but I am missing the model information.

willemcreffierKCWFB_0-1728979228998.png

 



Is there a way I can benefit both options?

Making a Selection of parameters in an Assemble view is not the ideal solution, I would like to store this somewhere in the EIR of our project, and load it from there.

Regarding your answer to @kevinQ3TQJ , what is the ideal way to compare versions of a project, without overloading Power BI?

I guess I would like to compare two versions all the time.

Previous versions & last version.

These versions are compared to another data set, the set that is the subject of the quality control.

Is it rational to import two identical tables , so I can easily  switch between both for each rapport?

Kind regards,

Willem



Message 4 of 6
kevinQ3TQJ
in reply to: kevinQ3TQJ

We were able to accomplish the project we were working on by using AssembleViews.Contents as our source, we were able to then use a "Default Power BI View" on each project and drill into the list of projects to dynamically generate the data for all the projects that we needed. 

 

@willem.creffierKCWFB, you could likely use a similar approach and have an old view referencing the old model and new view referencing the new model. In Assemble you could create the old view and link it to the old model, then link a new view with the new model.

Message 5 of 6

Hi @kevinQ3TQJ .

Does this implicate that you compose the same collection of columns in your "Default Power BI View"  for each project (manually)?

I would like to  organize it in a way, that in the future you are able to add parameters to an existing project.

Therefore I think it would be nice to source the names of the parameters externally....if possible.

Message 6 of 6
kevinQ3TQJ
in reply to: kevinQ3TQJ

@willem.creffierKCWFB, Yes, we created the view on one project and used the copy view function to replicate the same view to all projects and to the new projects when they are created.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report