Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need help to determine if it is possible to share data/queries between .pbix files and, if yes, the best way to do so.
We have created a number of Power BI data models in different .pbix files. We are starting to see opportunities to combine data/logic from one .pbix with data/logic from another .pbix. How to accomplish this without having to duplicate and manually recreate the logic?
An example might clarify. We have a Financials data model and an Operations data model. There are obvious opportunities to create ratio or % metrics by combining the two. Is there a way that the Financials .pbix can reference data/logic in the Operations .pbix? If there is more than one way, what are the pros/cons of the different options?
Hi @brianmcavoy,
So far you could not reference between multiple pbix files even though you could use Q&A feature with tips to query with natural language from multiple reports/datasets in dashboard. but this approach is good when
Which is good between creating separated data model and combination?
In my mind, there is no one good or not good. it's your ability to design & maintain based on your organization needs. In the first stage, we just implement specific reports for each departments, so it's good to have separated data model that fits their business (operation or financials). There is no confusing and no redundant.
After that there are some needs from higher managements that they need information from both of Fin & Op, so in this case we need consider their requirement basic or complexity
To combine 2 data models, you just do it manually by copy queries in Query Editor, calculated measures/columns. The layout of reports will need to be re-created manually 😞 But the good new will be updated in the end of Jan-2017 as https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14114169-allow-copy-and-paste-bet...
At this point, what would be the best wy to handle the sharing of colun/measures? I was thinking of creating an excel data dictionary file which basically lists the name sof the calculated measures, their content and the tables they reference/belong. Is there a better way of doing this?
Hi @sieed,
Actually, that's what i'm doing when delivering PBI project for customers. I have to document measures and its meaning, references to excel file.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |