cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Temoryian
Regular Visitor

Developing & Sharing Data Models

Hello,

 

I'm trying to figure out the right approach to build and share data models in Power BI and was hoping for your collective expert advise.  I have a need to define relationships between tables and save the models to allow other users to use them as a static base to build reports.  I think that sharing datasets may be the way to go as I can then assign security by user or group.  However, some of the joins required are by more than one field.  I've read that you can create concantenated fields to build unique ID's in both tables (fact & dimension) and then just join on the newly created fields.  With that being said, in some models I could end up creating multiple new calculated columns just to facilitate the joins and I'm not sure if that is the way to go.

 

Most of the tables I need to model are Oracle DB tables.  Occassionally I need to mix in other data sources to include .csv files.   How are Power BI developers defining these relationships and sharing them?  Are shared datasets the way to go?  Does anyone use modeling software as an intermediary to define the model and just connect Power BI to it?  For those of you who may have used Hyperion Interactive Reporting, I'm esentially trying to build and share data models similarly to that.

 

Thanks for any pointers you can help me with.  Much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-lionel-msft
Microsoft

Re: Developing & Sharing Data Models

Hi @Temoryian ,

 

About creating data model in Power BI

Power BI for Data Modelling 

Create model relationships in Power BI Desktop 

 

About sharing your data model in Power BI Service

Ways to share your work in Power BI 

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
Microsoft v-lionel-msft
Microsoft

Re: Developing & Sharing Data Models

Hi @Temoryian ,

 

About creating data model in Power BI

Power BI for Data Modelling 

Create model relationships in Power BI Desktop 

 

About sharing your data model in Power BI Service

Ways to share your work in Power BI 

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors