Combine several pbix models into a single repository

[webportal]

Hello,

I have a collection of .pbix models that follow a similar structure, ie, have the same tables and relationships.

It is too complex to combine them all into a single .pbix.

Is there a way to upload all these tables into a single repository, like PBI Service dataflows or a data warehouse, or something similar.

And then get the data back to PBI Desktop and perform DAX calculations, visualizations and report.

Any suggestions/ ideas?

Thank you so much for helping!

[v-diye-msft]

Hi @webportal 

If you’d like to combine several xmls under the folder , you can refer to the official document: https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries then all of them are combined into one table, you can add the measures on the whole data.

If you’d like to create the same visual/measure on every xml, you can firstly connect to one of them, and create the visual and measures then save it as a pbit file , then each xml you opened can apply the same visual and measures when you import the pbit . please refer to the official document here: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Please keep me updated if it works above.

Best regards,

Dina Ye

[webportal]

Hi @v-diye-msft  thanks for helping.

I'm aware of those functionalities, but that's not what I want. I need a way to connect a single (visualization + DAX calculation) layer on top of mutliple .pbix data models.

As far as I know, the only way to do this would be to upload the tables of each of these models to a single data warehouse and then connect Power BI to it.

Is this possible to do with Power BI somehow?

[v-diye-msft]

Hi @webportal ,

Sorry I don't think it's accessible currently. Probably you could raise the idea here 

https://ideas.powerbi.com/forums/265200-power-bi-ideas  for helping bring the feature coming.

Best regards,

Dina Ye