Data Model Entity Relationship documentation

DavidMoss · ‎10-18-2016

Does anyone know of a way of extracting the Realtionship view from PBI desktop into an Entity Relationship diagram client. ?

I am talking about th eview as seen at the top of this blog posting of @David Iseminger https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-relationship-view/

v-haibl-msft · ‎10-19-2016

@DavidMoss

What is the Entity Relationship diagram client you mentioned above? It seems that PBI doesn’t have such a function which can export the relationship view to other software. You can take a look at the document provided by ImkeF to see if it meets your requirement. And please vote this similar idea if it is the same idea as you.

Best Regards,

Herbert

DavidMoss · ‎10-19-2016

Hi @v-haibl-msft and thanks to @ImkeF for your continuous contribution to this community blog with fantastic links to great blog postinfs.

Yes @ImkeF documentation is cool but i was more after exporting to the likes of Visio or even Lucidcharts.

Meanwhile i added a vote to your 'idea' and manually created the Entity relationship 😞

ImkeF · ‎10-18-2016

Haven't worked with a client like that before, but if it would take in a table with the relationships, the new TMSCHEMA_RELATIONSHIPS DMV would do the job: https://datasavvy.me/2016/10/04/documenting-your-tabular-or-power-bi-model/

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries