cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emgee
Frequent Visitor

Create Relationships in Power BI Service Premium (Mac)

Hi. I've looked at all the Data Modelling / Create Relationship queries & docs and they're all for Desktop. 

Can someone please direct me to info on how to link tables in Premium per User, or where I can actually find it within Service Premium.

I'm on a Mac so don't have the option for Desktop.

2 ACCEPTED SOLUTIONS
blopez11
Memorable Member
Memorable Member

If you are looking for dataset authoring in the Power BI service, I don't believe it exists yet.  It appears to be coming, at least in public preview, March 2023: https://experience.dynamics.com/releaseplans/?app=Power+BI&planID=461a0550-0f02-ed11-82e4-000d3a9c6b...

 

I don't know all of your requirements, but maybe using datamarts in the power bi service can be a stop gap, as it a creates a dataset and has some ability to create measures as well.  I haven't used it, but maybe worth looking into for you: https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-overview

 

Good luck,

 

 

View solution in original post

@blopez11 is correct, Datamarts are the only place there's currently cloud-based modeling, but they're in preview and not suitable for production use yet.

 

As an alternative, relationships can be created programmatically using TMSL or TOM scripting:

https://www.oliviertravers.com/power-bi-programmatic-options-rest-apis-powershell-tmsl-tom-tabular-e...

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

2 REPLIES 2
blopez11
Memorable Member
Memorable Member

If you are looking for dataset authoring in the Power BI service, I don't believe it exists yet.  It appears to be coming, at least in public preview, March 2023: https://experience.dynamics.com/releaseplans/?app=Power+BI&planID=461a0550-0f02-ed11-82e4-000d3a9c6b...

 

I don't know all of your requirements, but maybe using datamarts in the power bi service can be a stop gap, as it a creates a dataset and has some ability to create measures as well.  I haven't used it, but maybe worth looking into for you: https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-overview

 

Good luck,

 

 

@blopez11 is correct, Datamarts are the only place there's currently cloud-based modeling, but they're in preview and not suitable for production use yet.

 

As an alternative, relationships can be created programmatically using TMSL or TOM scripting:

https://www.oliviertravers.com/power-bi-programmatic-options-rest-apis-powershell-tmsl-tom-tabular-e...

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors