The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @sanglq1,
According to the screenshot from you, you are using live connect to Power BI datasets. In Live Connection mode, you couldn’t build relationships by design. If you would like to create relationships when your data source is Power BI dataset, you need to enable Direct Query for Power BI datasets and AS option firstly. After that, restart the Power BI Desktop and you can switch the connection mode to Direct Query. With Direct Query mode, you could build relationships.
For more details about Direct Query to Power BI datasets, you could refer to
DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | ...
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Caiyun