The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |