Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
82 | |
79 | |
65 | |
48 | |
45 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
39 |