Create Relationships in Power BI Service Premium (Mac)

[emgee]

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.

[blopez11 · Accepted solution]

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 · Accepted solution]

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,

[otravers · Accepted solution]

@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...