Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! 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
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:
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.