Skip to main content
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: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

0
sarah99

Can not change storage mode to Import or estabilish a relationship between tables.

Submitted by on ‎09-27-2023 03:00 AM

Hi,

 

I've been strugging with building a relationship between my tables. Everything in the Create Relationship window is not available (cannot select another table).

Screenshot (226).png

The data source is a DirectQuery to AS - PowerBI Dataset. I've tried changing the storage mode but this seems to be disabled. 

Screenshot (225).png

I need a one-to-one relationship between the tables so that my filters affect all the visuals I've made. 

 

Also, I can't make any changes to the table as the Query Editor also seems disabled. 

Screenshot (227).png

 

Grateful if someone can help me with this.

Status: Delivered

Hi @sarah99 ,

 

It's a limitation for now. Use composite models in Power BI Desktop - Power BI | Microsoft Learn

If you would like to suggest  feature improvements, you may vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

 

Best Regards,
Community Support Team _ Caitlyn

 

 

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎09-28-2023 02:10 AM
Status changed to: Delivered

Hi @sarah99 ,

 

It's a limitation for now. Use composite models in Power BI Desktop - Power BI | Microsoft Learn

If you would like to suggest  feature improvements, you may vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

 

Best Regards,
Community Support Team _ Caitlyn

 

 

Idea Statuses