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?
Solved! Go to Solution.
Solved by kevinQ3TQJ. Go to Solution.
@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.
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.
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
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.
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.
@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.