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.
Go to 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
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:
Find out more about the March 2023 update.
In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.