cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

0
sanglq1

Why am I not able to use relationship? My two tables have a same column (and same same content)

Submitted by on ‎08-10-2022 03:22 PM

And my license is POWER BI PRO. Please support. Thanks.

asdq2e.png

Status: Delivered

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.

vcazhengmsft_0-1660185246903.png

 

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

See more ideas labeled with:
1 Comment (1 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎08-10-2022 07:34 PM
Status changed to: Delivered

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.

vcazhengmsft_0-1660185246903.png

 

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

Idea Statuses