Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I want to build relationships of the dataset that is in the datamart. The connection shows "connected live to the power BI dataset". However, the manage relationships button is greyed out. How can I build relationships for the datasets in powerbi datamart?
This screenshot is the data flow in powerbi. It will auto-refresh regularly.
Which datasource do you use in the underlaying source of the datamart? Perhaps its is a live connection?
Proud to be a Super User!
Hi, it is a live connection. This data source is connected to SSMS to the datamart. In this case, how can I still create relationships?
You have to create in SSMS. I think. please check the feature of a live connection.
Proud to be a Super User!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
93 | |
60 | |
47 | |
35 | |
34 |